Link to home
Create AccountLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

asked on

Subtract a time from a time amount in a cell using a formula in another cell.

I have a spreadsheet to calculate time worked in a week.
The daily times are added together.
Then an amount of 45 hours should be deducted from the weekly time to calculate the overtime.
I get the weekly total time (R8), but cannot create the formula to subtract 45 hours from R8 in U8.
Put differently: How do I write a formula in U8 that gives me the total time in R8 minus 45 hours?
Picture below and worksheet attached.
User generated imageTime.xlsx
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

u8 = R8 - time(45, 0, 0)
You can use this formula in Cell U8:
=R8-TIME(45,0,0)

Open in new window


This is the normal format for the TIME function. You can also include minutes and seconds in the appropriate sections, if needed.

TIME ( hours, minutes, seconds)
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I stand corrected, good to know.
Avatar of Fritz Paul

ASKER

Thanks. Superb.