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
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