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
Acknowledge(0)
Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
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 windows.
f) Using the subtraction formula, you will be able to calculate the time difference.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(2)
Amend(0)
8072Use 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 windows.
f) Using the subtraction formula, you will be able to calculate the time difference.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(2)Amend(0)
Dineshsir,
Thank you for this kind help. However, when I have an entry like:
- In time: 19:33
- Out time: 00:02
This formula doesn't work; it gives a result like "######". In short, I want to know if there is any formula that works even after day changes.
Thank you in advance and hope to get a solution.
From India, Pune
Acknowledge(0)Amend(0)
Thank you for this kind help. However, when I have an entry like:
- In time: 19:33
- Out time: 00:02
This formula doesn't work; it gives a result like "######". In short, I want to know if there is any formula that works even after day changes.
Thank you in advance and hope to get a solution.
From India, Pune
Acknowledge(0)Amend(0)
Dear Nissar,
Those using a biometric device for recording attendance for the purpose of wages calculation are required to use software for the calculation of attendance and overtime. The Excel sheet calculation is difficult because of the following reasons:
a) Real-time IN & Shift timing
b) Shift ending & real-time Out
The date & time change occurs at midnight, and shift duty change calculation becomes problematic.
From India, Mumbai
Acknowledge(1)Amend(0)
Those using a biometric device for recording attendance for the purpose of wages calculation are required to use software for the calculation of attendance and overtime. The Excel sheet calculation is difficult because of the following reasons:
a) Real-time IN & Shift timing
b) Shift ending & real-time Out
The date & time change occurs at midnight, and shift duty change calculation becomes problematic.
From India, Mumbai
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt