[h] : mm:ss

O

Omar

Dear Experts,
May I ask you what the following function does?
Format cells → Number → Custom → [h] : mm:ss.
Thanks.
 
G

Guest

It allows the cell to show hours in excess of 24hrs. For example formatted as
hh.mm.ss entering 25:30 mins would display 01:30.

Formatted as below would display 25:30
 

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

Similar Threads

Displaying negative [h]:mm:ss 2
convert time 2
Negative hours [h]:mm:ss 5
Multiplying time by cost 2
Adding sum of coloured cells 1
Excel 2003 - Time Formats 5
### showing up in pivot table. 2
Excel Convert Datetime Stamp to HH and MM Worked 7

Top