Example: Tool Rental

A customer rents a tool on a specific date and time. He returns it the next
day at a specific time. I would appreciate any assistance in obtaining a
formula for the following:

Cell A1 (Time Rented - 1100 Hours) Cell B1 (Date Rented - 01/01/2006) Cell
C1 (Time Returned - 1430 Hours) Cell D1 (Date Returned - 01/02/2006) Cell E1
(Total Time Out) for Tool in hours and minutes. As long as the date does not
change, I can get the formula to compute the length of time the tool is out,
however, when the date changes as shown above, I need to know how to figure
it to include the next calendar day. I'd prefer using military time as also
shown, so my end results in Cell E1 (in this example) would show the tool was
out for 27 Hours and 30 Minutes . Any assistance would be greatly appreciated.

Thank you
Dave

Hi Dave

Try
=(D1+C1)-(B1+A1)
Format the cell with the formula FormatcellsNumberCustom [hh]:mm

--
Regards

Roger Govier


"Dave" wrote in message
...
Example: Tool Rental

A customer rents a tool on a specific date and time. He returns it the
next
day at a specific time. I would appreciate any assistance in obtaining
a
formula for the following:

Cell A1 (Time Rented - 1100 Hours) Cell B1 (Date Rented - 01/01/2006)
Cell
C1 (Time Returned - 1430 Hours) Cell D1 (Date Returned - 01/02/2006)
Cell E1
(Total Time Out) for Tool in hours and minutes. As long as the date
does not
change, I can get the formula to compute the length of time the tool
is out,
however, when the date changes as shown above, I need to know how to
figure
it to include the next calendar day. I'd prefer using military time as
also
shown, so my end results in Cell E1 (in this example) would show the
tool was
out for 27 Hours and 30 Minutes . Any assistance would be greatly
appreciated.

Thank you
Dave