F5F Stay Refreshed Software General Software Here is how you can add a new time column to your spreadsheet.

Here is how you can add a new time column to your spreadsheet.

Here is how you can add a new time column to your spreadsheet.

Pages (2): Previous 1 2
G
glenroi
Member
Find
164
06-01-2026, 10:36 AM
#11
Yes, what I did is add 24 to the result of SUM(F5:F54) and put it in cell F55. Then, for cell F56, I used =INT() to round down and ROUND(...,0) to get a number with two decimal places to show hours and minutes. This formats the sum into hours and min format.
Reply
Reply
G
glenroi
06-01-2026, 10:36 AM #11

Yes, what I did is add 24 to the result of SUM(F5:F54) and put it in cell F55. Then, for cell F56, I used =INT() to round down and ROUND(...,0) to get a number with two decimal places to show hours and minutes. This formats the sum into hours and min format.

Reply
Reply
Pages (2): Previous 1 2