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 :)
--
oldLearner57

Try this:

A1 = time in
B1 = time out

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

Format as h:mm

--
Biff
Microsoft Excel MVP


"oldLearner57" wrote in message
...
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 :)
--
oldLearner57

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

"oldLearner57" wrote:

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 :)
--
oldLearner57Hi