Calculations from date and time values
On Wed, 23 Nov 2005 08:11:01 -0800, "kp" wrote:
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
You're welcome. Glad you got it to work!
--ron
|