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?
|