Calculations from date and time values
Finally, the formula was not designed to be applied to just the time column. I
would expect that under certain circumstances, when used in that fashion, you
would obtain results different from what you expect.
Do you still have a date column?
If so, just combine the two columns within the formula:
=((B1+C1)-($B$1+$C$1))*1440
Be sure to format the result as General, or as Number with the desired number
of decimal places.
--ron
Ron:
Worked perfect - thanks!
kp
|