Hi,
Sorry, ignore my previous reply!

Should be:

=IF(OR(A1="",B1=""),"",INT((B1-A1)*24+0.5))


"Toppers" wrote:

Hi,
Assuming dates are held in format dd/mm/yyyy HH:MM then simple
subtract two dates and multiply by 24.

e.g in c1 put = INT((B1-A1)*24+0.5)

03/06/2006 20:00 (A1)

05/06/2006 20:29 (B1)

C1=48

HTH

" wrote:

Hi Everyone,

How can I calculate the time elapsed between two given times?
For example if I input initial time and date as 20:00 on 03 Jan 06 and
final time and date as 05:00 on 05 Jan 06, I want to calculate the
number of hours elapsed. Moreover I am interested in whole numbers i.e.
8 hours and 31 minutes should round to 9 hours and 8 hours and 29
minutes should round to 8 hours. I need to multiply this time elapsed
with another constant quantity?

Any help would be appreciated.

regards