Formulas

Posted by Susan on November 12, 2001 8:57 AM

I NEED HELP WITH A FORMULA

I AM TRYING TO DO FORMULAS WITH TIME

EXAMPLE

7:30 12:00 1:00 4:30 8

I CANNOT FIND A FORMULA IN EXCEL TO DO THIS FOR ME I AM TRYING TO DO THIS FOR TIME CARDS SO THE HOURS MAY NOT ALWAYS BE ROUNDED THIS WAY PLEASE HELP IF YOU CAN THANKS

Posted by Barrie Davidson on November 12, 2001 9:14 AM

Assuming your times are in cells A1 to D1 respectively and you have cell E1 (8) formatted as a number (not time), you can put this formul in cell E1.

=(D1-C1+B1-A1)*24

Is this what you need?

BarrieBarrie Davidson