How do you display a time variance in negative numbers?
R RagDyer Mar 19, 2009 #3 If by time variance you mean, say hours difference between 2 cells: A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5.
If by time variance you mean, say hours difference between 2 cells: A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5.
S seadog471 Mar 20, 2009 #4 RagDyer said: If by time variance you mean, say hours difference between 2 cells: A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5. Click to expand...
RagDyer said: If by time variance you mean, say hours difference between 2 cells: A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5. Click to expand...
