Excel assistance: Tracking elapsed time

  • Thread starter Thread starter rwdutton
  • Start date Start date
R

rwdutton

Here's the problem:
I have H5, date of issue (mm/dd/yyyy); I5, hour of issu
(00:00:00)note: 24 hour clock; J5, date of customer receip
(mm/dd/yyyy); K5, hour of customer receipt (00:00:00) note: 24 hou
clock. What I am trying to do is capture elapsed time from issue t
receipt. Some issues and receipts occur on the same day which negates
need to convert date to hours, the proble is when the following occurs
H5, 4/21/2004; I5, 15:17:00, J5, 4/24/2004; K5, 13:08:01. Can anyon
help with a formula that I can apply to capture the total elapsed time
 
rw,

If these are being put in as real times, you can add the date and time of
receipt cells, and subtract them from the sum of the date and time of issue.
The first set of () is for clarity only.

=(J5+K5)-(H5+I5)

Format (Format - Cells - Number - Custom) as:

d "days" h "hrs" m "min"
[h] "hrs" m "min"

The 12/24 hour thing doesn't matter. It works either way. You can also
put the date and time into a single cell. Then just subtract receipt from
issue and format.
 
Back
Top