Okay, thanks!
"Barb R." wrote:
First, you'll need to subtract the END TIME from the START TIME.
Let's say
Start time A1= 7:30 AM
End Time B1 = 12:00 PM
C1 = (B1-A1)*24 and format C1 to NUMBER with 2 decimal places.
"quartz" wrote:
I'm blanking on this:
Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?
TIA
|