ExcelBanter - Calculating the difference between hours

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calculating the difference between hours (https://www.excelbanter.com/excel-programming/312397-calculating-difference-between-hours.html)

Sambusa[_7_]

Calculating the difference between hours

Is there any one ,pls ?

SAM

--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496
View this thread: http://www.excelforum.com/showthread.php?threadid=26588

Tom Ogilvy

Calculating the difference between hours

the times must be in time format

6:00

and

14:00

the formula then gave me 31.35 hrs.

What should the right answer be?

--
Regards,
Tom Ogilvy

"Sambusa" wrote in message
...

Is there any one ,pls ?

SAMI

--
Sambusa
------------------------------------------------------------------------
Sambusa's Profile:
http://www.excelforum.com/member.php...o&userid=14960
View this thread: http://www.excelforum.com/showthread...hreadid=265883

All times are GMT +1. The time now is 12:31 AM.