totals

New Contributor

hi, im trying to work out total scheduled hours less sick hours, holiday hours, furloughed hours, public holiday hours, annual leave hours, walk to work hours

Hours Scheduled d2

Less

Hours Sick e2

hours furloughed f2

hours annual leave g2

Hours public holiday h2

Hours walk to work i2

Actual Hours Worked j2

 

Thanks

 

 

 

 

 

5 Replies

@kjgill 

Perhaps

=D2 - SUM( E2:I2 )
Hi thanks but that doesnt work

@kjgill 

I may only guess how your data looks like. If assume as

image.png

it works. Here elapsed time format [hh]:mm is applied.

Where do i find lapsed time format please

@kjgill 

Select cells with time, Ctrl+1, Custom, type [hh]:mm, Ok

image.png