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

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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
 
Back
Top