Calculating number of hours and minutes
 

Please can someone tell me how to calculate the number of hours and minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours 30
minutes.

Calculating number of hours and minutes
 

If the date and time are in the same cell then simply suntract the two cells
and custom format as [h]:nn

If the dates and times are in different cells then with tahe dates in Column
A and the times in Columns B use:

=(A2+B2)-(A1+B1)

Custom Formatted as above.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours
30
minutes.

Calculating number of hours and minutes
 

Hi Neville,

With your start date/time in A1 and your end date/time in B1
then put =B1-A1 in C1 and format C1 as custom [h]:mm

HTH
Martin


"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours
30
minutes.

Calculating number of hours and minutes
 

=last date - first date
and format userdefined as [h]:mm


"Neville" skrev:

Please can someone tell me how to calculate the number of hours and minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours 30
minutes.

Calculating number of hours and minutes
 

Try this
=INT(A1-A2)*24&" hours "&INT(MOD((A1-A2),1)*60*24) & " minutes"

--
Don Guillett
SalesAid Software

"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours
30
minutes.

Calculating number of hours and minutes
 

Thank you very much, Sandy! Works like a charm!

"Sandy Mann" wrote:

If the date and time are in the same cell then simply suntract the two cells
and custom format as [h]:nn

If the dates and times are in different cells then with tahe dates in Column
A and the times in Columns B use:

=(A2+B2)-(A1+B1)

Custom Formatted as above.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours
30
minutes.

Calculating number of hours and minutes
 

You're very welcome, thanks for the feedback.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Neville" wrote in message
...
Thank you very much, Sandy! Works like a charm!

"Sandy Mann" wrote:

If the date and time are in the same cell then simply suntract the two
cells
and custom format as [h]:nn

If the dates and times are in different cells then with tahe dates in
Column
A and the times in Columns B use:

=(A2+B2)-(A1+B1)

Custom Formatted as above.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending
time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72
hours
30
minutes.