46 posts tagged with "Excel"

You don't need the Excel app to start a workbook. From any folder in OneDrive, Create or upload → Excel workbook opens a blank workbook in Excel for the web, and it's saved in that folder from the first moment.

I added a time to a date with =B6+TIME(1,0,0) and Excel showed 29/03/2026, with no 01:00. The time was in the cell: its Date format just didn't show times. Excel for the web's Number Format list has no date-and-time option, but the custom format dd/mm/yyyy hh:mm shows both.

I added up a timesheet's Time worked column with SUM and got 12:15. The shifts came to 60 hours 15 minutes. The total was right, but its format, hh:mm, shows a time of day, so it dropped every whole 24 hours. The custom format [h]:mm shows 60:15.

To turn each shift's time worked into decimal hours, I multiplied it by 24. Excel showed 12:00, 00:00 and 18:00 instead of 3.5, 4 and 3.75. The numbers were right. The new column had picked up a time format, and switching it to Number fixed it.

In my overtime timesheet, =[@Finish]-[@Start] gave the right hours for every daytime shift and ######## for every shift that ended after midnight. Those subtractions came out negative, and Excel can't show a negative time. Wrapping the subtraction in MOD(…, 1) fixed it.

I pasted fourteen rows of overtime into Excel for the web, and the whole Date column turned into ########. Nothing was wrong with the dates: the column was too narrow to show them, and AutoFit Column Width fixed it in one click.