I get employee in & out report from biometric. For example 18:46 as in time & 23:57 as out time in excel format. I want to calculate difference between these 2 times in excel. Please help out me.
From India, Pune
From India, Pune
Dear Nissar,
Use the following procedure:
a) Select the cell. After selecting, right click your mouse
b) Select "Format Cells". When you do that, a new window emerges
c) In the new window, in the category section, select "time"
d) When we select "time", on the right side we get "types", select 1330 (or 24-hour clock time format)
e) Do this for both the windows
f) Using the subtraction formula, you will be able to calculate the time difference.
Thanks,
Dinesh Divekar
From India, Bangalore
7855Use the following procedure:
a) Select the cell. After selecting, right click your mouse
b) Select "Format Cells". When you do that, a new window emerges
c) In the new window, in the category section, select "time"
d) When we select "time", on the right side we get "types", select 1330 (or 24-hour clock time format)
e) Do this for both the windows
f) Using the subtraction formula, you will be able to calculate the time difference.
Thanks,
Dinesh Divekar
From India, Bangalore
Dineshsir, Thanking you for this kind help. But when I have entry like
in time - 19:33 & out time - 00.02
this formula doesn't work. It gives result like ######
In short, I want to know any formula that works even after day changes.
Thanking in advance & hope to get any solution.
From India, Pune
in time - 19:33 & out time - 00.02
this formula doesn't work. It gives result like ######
In short, I want to know any formula that works even after day changes.
Thanking in advance & hope to get any solution.
From India, Pune
Dear Nissar,
Those are using biometric device for recording attendance for the purpose of wages calculation.They are required to use software for calculation of attendance and over time. The XL sheet calculation is difficult because:
a) Real time IN & Shift timing
b)Shift ending & real time Out
The date & time cahnge occurs in mid-night & shift duty change calculation becomes problematic.
From India, Mumbai
Those are using biometric device for recording attendance for the purpose of wages calculation.They are required to use software for calculation of attendance and over time. The XL sheet calculation is difficult because:
a) Real time IN & Shift timing
b)Shift ending & real time Out
The date & time cahnge occurs in mid-night & shift duty change calculation becomes problematic.
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
PF Calculation Sheet To The Subscribers At the Time Of Provident Fund Withdrawal.pdf
Date difference between two dates calculation.xls