Hello I need help with an Excel spreadsheet. I have one that is set as a table with days of the month and starting times (of a workday) in one column, the ending time (in the 24 hour format) in the second and the total hours and minutes worked in the third. I would like to add up the total hours in minutes worked so far as a running total that adds up the time correctly but have not found the way despite my exploration. Can anyone help?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Excel help needed
- Thread starter decafjava
- Start date
- Sort by reaction score
You mean, the results >24 hours going wrong ?
Attachments
Last edited:
I posted a screenshot with numbers, formulas and results.
Can you do the same perhaps?
Couldn't manipulate the spreadsheet, but it's resetting the total column when it trips over 24 hours as in the 4th entry.
Convert column C to a decimal number, i.e. 8:40 = 8.66 and it will work as is.
Convert column C to a decimal number, i.e. 8:40 = 8.66 and it will work as is.
Actually, just multiply column D * 24 and you'll have a useful numeric total (i.e. sum($c$2:c2)*24).
Can leave column C formatted as Time.
Can leave column C formatted as Time.
Last edited: