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.
![The example worksheet picture.]()
Time.xlsx
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.
Time.xlsx
Microsoft Excel
Last Comment
Fritz Paul
u8 = R8 - time(45, 0, 0)
You can use this formula in Cell U8:
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)
=R8-TIME(45,0,0)
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I stand corrected, good to know.
ASKER
Thanks. Superb.