Thread: [h] : mm:ss
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default [h] : mm:ss

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

"Omar" wrote:

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