Time Formulas

M

metaltecks

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?
 
D

daddylonglegs

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
 
Top