Thread: formulas

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 Format>cells>Number>Custom> [hh]:mm

--
Regards

Roger Govier


"Dave" <Dave@discussions.microsoft.com> wrote in message
news:AC9BD9A2-2B29-49D1-835C-299B2245B2C9@microsoft.com...
> 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
>