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

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

[h]:mm

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

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top