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.
I have a list of volunteer times in hours and minutes on a spreadsheet, like 1:30 or 2:45. I want to know how to add a new column that calculates the total sum for those numbers. The formula =SUM(F5:F45) isn't working for me. Thanks.
You should have those times listed in cells with a time format. Your total won't work because they are written as text, not numbers. If you click inside one of the cells that says "1:30," does the formula bar show "01:30:00 AM"? Yes! That shows Excel knows it's actually a time and not just plain text.
To add or subtract time in Microsoft Office, visit this link: https://support.microsoft.com/en-us/offi...98a7cad6ad