PDA

View Full Version : Solved: TIME DIFFERENCE FORMULA REQUIRED



Sathisc
06-03-2010, 12:23 AM
Hi,

I need to find out the time difference

example

A1 = 6/1/2010 8:20

B1 = 6/3/2010 8:22

i want the time difference in the column C1 in Hrs and Minutes

Thanks in Advance

Sathish

Bob Phillips
06-03-2010, 12:30 AM
Just use

=B1-A1

and format as [h]:mm

Sathisc
06-03-2010, 12:36 AM
Thanks for your reply,

I want the data also to be taken into count

ie for the above example the difference should be 50 hrs and 0 mins

Sathisc
06-03-2010, 12:37 AM
sorry i mentioned wrongly the date as data

Bob Phillips
06-03-2010, 12:44 AM
So, as I said, just use

=B1-A1

and format as [h]:mm

And actually that difference in the above example is 48 hours and 2 minutes.

Try it!

Sathisc
06-03-2010, 12:56 AM
THANK YOU SO MUCH MATE