Time Differnece Formula

Posts: 7
Joined: Wed Sep 03, 2014 6:29 am

Time Differnece Formula

Postby skmittal1979 » Mon Sep 29, 2014 10:38 am


Please suggest which formula should be used. Example if
In Time : 8:10 IST
Out Time: 18:20 IST
Shift Timing : 9:00 Hrs

Formula We can use: =Mod(Out Time-In Time,1) but it gives only positive Hrs means if a person have more then 9 hrs shift. I want to know the formula for which I can know if one person have less then 9 hrs shift in a day. Mode function gives only positive number if shift time is more then 9 hrs but not less then.

I hope i will get the resolution ASAP of this query.

Now I want to calculate OT hrs so please suggest how to calculate.

Finance Junkie
Posts: 944
Joined: Wed Apr 09, 2014 6:28 am

Time Differnece Formula

Postby edupristine » Mon Oct 06, 2014 1:57 pm

First you need to convert it into time format by using this formula ==HOUR(Cell1)+MINUTE(Cell1)/60.
After doing this please change the cell format by pressing Ctrl+Shift+1.
Example:- (10:00-14.20-9)*60= -280 minutes.
Here is your minimum login time is 9:00 HRS and this time you are short of 28 minutes.

Hope this helps.

Return to “FRM Part II”


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.