Time Formulas
 

I have a formula in column s that calculates the difference in time from two
other columns. Then in column T, the answer of column s is converted into
actual minutes.

I need to create another formula, but everytime I use the converted minutes
in column T, it gives me an error. Is there a way I can calculate with these
numbers as is, or do I have to change them to general numbers, and then run
my formula?

Time Formulas
 

Sounds like you might be converting to minutes by using some sort of
TEXT formula. If so then you might have a problem using the result if
it's text.

To calculate the difference between two time values in minutes

=(B1-A1)*1440

format as number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527789