Calculating time between two dates
 

In A1 enter 39101.6666666667

In B1 enter 39104.4583333333

In C1 enter =B1-A1
and you should see 2.7916666667

format A1 thru C1 as custom:
m/d/yyyy h:mm:ss
m/d/yyyy h:mm:ss
[h]:mm

and see:
1/19/2007 16:00:00 1/22/2007 11:00:00 67:00


--
Gary''s Student
gsnu200701


"Sujith" wrote:

Hi,

I am making a report in which I want the time differance between two dates.
Eg: In A1 the value is 19/01/2007 16:00:00
In B1 the value is 22/01/2007 11:00:00

A1 is responded time for an issue and B1 is resolved time.
I want the result in C1 as the time differance i.e. B1-A1. When I refered
the posts here, the formula =B1-A1 works only with MMDDYY format and does not
work with my time format which is DDMMYY.

I also want a formula to make excemption of holidays and off hours, say 20th
and 21st Jan are holidays and working hours are from 9:00 to 18:00.

Thanks,
Sujith