Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Calculating time, hours and minutes | Excel Discussion (Misc queries) | |||
calculating fees from hours and minutes | Excel Worksheet Functions | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions |