Time calculation

  • Thread starter Thread starter smi
  • Start date Start date
S

smi

Hello group,

Please help. I need a subtract formula to have exact hours and minutes of
these two cells.

These are format as dd/mm/yy hh:mm.

A1 = 11/02/03 21:15
A2 = 11/04/03 01:45
It should come out as 28 hrs 30 minutes.
My formula =(A2-A1)*1440/60 give me 28.50

Thank you for your time.
Long
 
Thank you

Peo Sjoblom said:
Format result as [h]:mm

--

Regards,

Peo Sjoblom

smi said:
Hello group,

Please help. I need a subtract formula to have exact hours and minutes of
these two cells.

These are format as dd/mm/yy hh:mm.

A1 = 11/02/03 21:15
A2 = 11/04/03 01:45
It should come out as 28 hrs 30 minutes.
My formula =(A2-A1)*1440/60 give me 28.50

Thank you for your time.
Long
Click to expand...
Click to expand...
 
Hello group,

Please help. I need a subtract formula to have exact hours and minutes of
these two cells.

These are format as dd/mm/yy hh:mm.

A1 = 11/02/03 21:15
A2 = 11/04/03 01:45
It should come out as 28 hrs 30 minutes.
My formula =(A2-A1)*1440/60 give me 28.50

Thank you for your time.
Long
Click to expand...

=A2-A1 and format the result as [h]:mm or, literally, as

[h]" hrs "mm" minutes"




--ron
 
Back
Top