Time formula

[jackdiamond]

Hi,

I want to write a formula that will work out the difference between 2 times and dates.

eg:

Cell a1 = 01/04/2011 01:30
Cell a2 = 02/04/2011 13:30
Cell a3 = 36

Does anyone know how I can do this please?

Ta
STu

 

[T. Valko]

Hi,

I want to write a formula that will work out the difference between 2 times and dates.

eg:

Cell a1 = 01/04/2011 01:30
Cell a2 = 02/04/2011 13:30
Cell a3 = 36

Does anyone know how I can do this please?

Ta
STu

Well, I couldn't figure out how you got 36 then I realized the dates may be in d/m/y format!

Try this...

=(A2-A1)*24

Format as General or Number

 

[CWatts]

I dont understand what the 36 is(please clarify if i'm missing something), but you can use this formula:

=INT(A2-A1)&" Days "&TEXT(A2-A1-INT(A2-A1),"h:mm")

Edit: thanks Valko. I wish people would put locations in their profiles. Go with his formula then.