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
You should start by having those times inside cells set to time format so your sum works. This is because they are treated as text. If you click on a cell with "1:30", the formula bar actually shows something like "01:30:00 AM". That means Excel recognizes it as a real time, not just plain text.
Set up the cells to show times like this: 1:20, 2:30, 4:50, 8:40. It works! Just add all those numbers together using SUM, and put them in E1 to E6.
I have a list of fifty or more numbers, and they are all written as time. Some times go past 24 hours. For example, it might say 1:30 pm or even 3:45 am depending on the order. Right now, I want to find out how much everything adds up together. My formula =SUM(F5:F54) isn't working right. Maybe there is something in those cells that is making it break?
Use the sum of F3 to F54 and make sure the cell looks like a number. If it's set as a number, Excel gives you days by default. Multiplying by 24 turns those days into total hours. I tried with 29 rows for F6:16 and got about 181.73 hours. Do I really need to write down the minutes too, or is just the decimal part okay?
Check this out: https://webapps.stackexchange.com/questi...just-minut