Fritz Paul

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.

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

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 (

`=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

membership

Create an account to see this answer

Signing up is free. No credit card required.

I stand corrected, good to know.

ASKER

Thanks. Superb.