View Single Post
  #4   Report Post  
Mladen_Dj
 
Posts: n/a
Default how to calulate time in hours cbetween two different dates?

Correction:

Not divide, but multiply with 24, to get fraction of hours...

"Mladen_Dj" wrote in message
...
For result cell use custom number format "[h]", if you want to be display
minutes also then "[h]:00, and if you want to have fraction of hours, use
general format, and divide result with 24.
---------------------------