Subtracting Dates

[ExcelRoy]

Hi guys,

is there a way i can subtract dates, so i can see how long i have left in days, hours, mins etc

ie

05/06/2011 21:22 i would like to subtract 05/06/2011 20:22 to show 1 hour remaining

Thanks

 

[martindwilson]

05/06/2011 21:22 - 05/06/2011 20:22 format cell dd HH:mm

 

[T. Valko]

Hi guys,

is there a way i can subtract dates, so i can see how long i have left in days, hours, mins etc

ie

05/06/2011 21:22 i would like to subtract 05/06/2011 20:22 to show 1 hour remaining

Thanks

Try this...

A2 = 05/06/2011 21:22
B2 = 05/06/2011 20:22

=INT(A2-B2)&" "&TEXT(MOD(A2-B2,1),"h:mm")

That will return 0 1:00

 

[T. Valko]

05/06/2011 21:22 - 05/06/2011 20:22 format cell dd HH:mm

Using a custom format like that, the max number of days that will be displayed is 31.

 

[ExcelRoy]

Thanks for your help guys

 

[T. Valko]

Thanks for your help guys

You're welcome!