CODEWITHSUNDEEP
exceltimeexcel-formula
MBrann
MBrann

Reputation: 265

Time not in 24 hour view

I am attempting to sum up hours per day across numerous fields. The issue I am encountering is when the sum passes 24 hour it defaults to 24 hour clock so 01:00:00 for 25 hours when actually I want it to show 25:00:00. Can anyone advise on this please? Many thanks,

Upvotes: 0

Views: 36

Answers (2)

lorgan
lorgan

Reputation: 163

Depends how your data is formatted - what happens if you change the custom number format to this: [h]:mm:ss

enter image description here

Upvotes: 2

Gordon
Gordon

Reputation: 1165

The time is stored as a number by Excel and it will only show from 0 to 24 hours. If you format the cell as a number it should be 1.04 which Excel sees as 1.04 days and only uses the .04 when formatted as a time. Add *24 to your calculation and you will get 25.00.

It's a little more tricky to get your desired format hh:mm:as but I'll have a go and get back to you shortly.

Upvotes: 0

Related Questions