Formula for cycle time

[JBell]

Hi,
I need a formula to determine cycle time... actually to
calculate the number of days from the date in one cell to
the date in the other and put it in a third cell... thank
you!
JBell

 

[JE McGimpsey]

XL stores times as integer offsets from a base date, so you can use
regular math functions:

=A2 - A1

 

[Frank Kabel]

Hi
just subtract them like
=A2-A1
and format the resulting cell as number.

 

[CLR]

=DATEDIF(A1,B1,"d")

Vaya con Dios,
Chuck, CABGx3