Calculating differences between two dates with time.

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I need to calculate cycle time between two fields:
A B
5/18/2004 9:08:48 AM 5/6/2004 12:08:20 PM

A-B does not work. Can someone tell me the correct
formula?

Thanks!

Sean
 
Hi Sean
What do you mean by "does not work"? Are the date/time values text or are they formatted numbers

If they are formatted numbers then A1-B1 calculates to 285:00:28. The result cell has a custom number format of [hh]:mm:ss. Or with a format of dd:hh:mm:ss you will get 11:21:00:28

If the date/time values are text try the formula

=VALUE(A1)-VALUE(B1

Excel should be able to convert them

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Sean wrote: ----

I need to calculate cycle time between two fields
A
5/18/2004 9:08:48 AM 5/6/2004 12:08:20 P

A-B does not work. Can someone tell me the correct
formula

Thanks

Sean
 
Sean said:
I need to calculate cycle time between two fields:
A B
5/18/2004 9:08:48 AM 5/6/2004 12:08:20 PM

A-B does not work. Can someone tell me the correct
formula?

Thanks!

Sean
Click to expand...


You must insert cell's format like [hh].mm
..i
 
Back
Top