calculating times (hours and miniutes) on a time sheet

M

madtech

Hi I was wondering if anyone can help me with a formula that will calculate
times on a time sheet. I tried =TEXT(P18-P15,"h:mm") but don'y think this is
the one. I have a shift start time for example 8:26 AM and shift end at 6:15
PM and would like my hours worked to be calculated automatically. Thanks a
bunch!
 
B

Bearacade

Your formula works.. What exactly are you looking for? Why isn't i
working for you?

By entering your formula, I show 9 hours and 41 minute
 
Top