Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[h] : mm:ss
Dear Experts,
May I ask you what the following function does? Format cells †’ Number †’ Custom †’ [h] : mm:ss. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
[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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|