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

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.

"shonkoo" wrote in message
...
I use Excel 2003. I cannot find out time in hours between two different
dates, for example - time in hours between 2300 hrs/ 23.10.05 and 0800
hrs/26.10.05. Can anyone advise?