time claimed

[oldLearner57]

hi community

i have these 2 timing

time In time Out
08:00 18:00

wanted to find the time claimed that minus 1 hour of lunch x
....

can anybody kindly assist me on this?

10s community

 

[T. Valko]

Try this:

A1 = time in
B1 = time out

=B1-A1-TIME(1,0,0)

Format as h:mm

 

[Shane Devenshire]

Hi,

if time in is in A1 and time out in B1 then

=B1-A1-1/24

Format the range to [h]:mm:ss

If this helps, please click the Yes button

Cheers,
Shane Devenshire