How to subtract time

[rush2rajen]

Hi Excel Gurus,

I was making a attendance report. It had Ideal time in/out & actual time in/out.
For eg: if my Ideal in time is 10:00 am and out time is 18:00 pm and my actual in time is 10:10am ie late by 10 mins and out time is 18:30 pm ie exit was more than 30 mins
Then in deviation column in it should show -10 mins and exit time should be +30 mins.

Please suggest a formula for the same

Thanks
Raj

 

[Somendra Misra]

Hi Raj,

See your file.

Regards,

 

[rush2rajen]

Thanks a lot Misraji.