lani_berina
New Member
- Joined
- Dec 13, 2010
- Messages
- 5
Hi im having difficulties in calcuting this Daily Time Attendance below is the sample of what im trying to do. I am using the fomula of =MOD(TEXT(E8,"00\:00")-TEXT(D8,"00\:00"),1) in Hours Render and it give the right the answer; however there's a problem in calculating the deficit time using this formula =MOD(F8-G8,1) it gives wrong answer 8-8=8 it must be 0. If i enter 0700-1800 there will be an excess of 3:00. Anyone can provide some suggestions and answer to this post. Thank you.
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>