Determining Elasped Time.

  • Thread starter Thread starter Cindy Grover
  • Start date Start date
C

Cindy Grover

I have a project to determine how long it took a job to
print
Example
Column A Column B
start: End
01JUL04 09:30:00 01JUL04 10:20:15
These field are set to general. What function do I use or
what do I need to do to subtract A from B. I always get
#Value.
 
01JUL04 09:30:00 01JUL04 10:20:15

Not really sure .. but this seemed to work for me:

Copied the line above into A1
Clicked Data > Text to Columns > Next

In step2 of the wiz.:
Removed the leftmost and rightmost breaklines,
retained the centre breakline > clicked "Finish"

The line was split into A1 and B1
and Excel recognized the values in date/time format

Tried in C1: =B1-A1
Formatted C1 as "Custom" | Type: [h]:mm:ss > OK

C1 returned the correct value of "0:50:15"
 
Hi,

Here are some suggestions:

1) Format the cells (using the date formatting) or you
can use custom and type in mm/dd/yyyy

2) Text to columns

3) You can write a formula -

=right(A1,7)
 
Back
Top