Can you add up hours and minutes greater than 24 hours?

M

Mark

I am trying to add a column of time information (how long
a product has been functioning) but as soon as the amount
of time reaches 24 hours it reverts to 0 hours again and
starts a new 24 hour cycle. Can I force it to add 24 to
the total or otherwise make it add up to more than 24
hours
 
A

Andy Brown

Can I force it to add 24 to
the total or otherwise make it add up to more than 24
hours
Click to expand...

You need to apply a custom format to the total cell,

[h]:mm

, via Format -- Cells -- Number -- Custom.

Rgds,
Andy
 
Top