Night Differential Computation

[maeyks]

Hello,

I am doing time keeping for my <gs id="5c1fbd68-764c-4003-a2bc-4e1053f1fd1f" ginger_software_uiphraseguid="dbed60d9-28ed-4c15-b6e6-7c47a32085c9" class="GINGER_SOFTWARE_mark">emloyees</gs>. If their work schedule is from 12 noon until 9 pm but they extended work hours from 9 pm until 12 midnight, what is the best formula in computing night differential in excel if:

<gs id="4cf2a939-352d-43c0-912e-5846fd7de04d" ginger_software_uiphraseguid="4bd710a3-c1c1-4bbe-b95a-4b3acd82d4f8" class="GINGER_SOFTWARE_mark">night</gs> differential starts from 10 pm until 6 am the next day
<gs id="1e38aefc-9b39-42a1-8d84-44d12f3c75a7" ginger_software_uiphraseguid="1aca1484-9f5b-4640-a5fd-fcbc6549984e" class="GINGER_SOFTWARE_mark">night</gs> differential computation <gs id="8b5d8564-3ea7-4c85-b038-94c11bebf206" ginger_software_uiphraseguid="1aca1484-9f5b-4640-a5fd-fcbc6549984e" class="GINGER_SOFTWARE_mark">starts at</gs> least 1 hour (so night differential pay can be claimed by 11 am), and 30 minutes succeeding (11:00, 11:30, 12:00, 12:30, <gs id="d4828ef4-6b33-4d56-b00a-cf46cbdba822" ginger_software_uiphraseguid="1aca1484-9f5b-4640-a5fd-fcbc6549984e" class="GINGER_SOFTWARE_mark">etc</gs>)
<gs id="b61f91e9-141c-4a05-a2ff-b8fa758f1deb" ginger_software_uiphraseguid="9467ccc9-a752-44f6-8db7-83da7826a794" class="GINGER_SOFTWARE_mark">the</gs> value it will return is hours<gs id="c402de16-04b9-4253-b970-7ba0dbfa7767" ginger_software_uiphraseguid="9467ccc9-a752-44f6-8db7-83da7826a794" class="GINGER_SOFTWARE_mark">:</gs>minutes (1:00, 1:30, 2:00, <gs id="70a4d429-6bd7-49ec-9c0a-cf77e9f9b9ea" ginger_software_uiphraseguid="9467ccc9-a752-44f6-8db7-83da7826a794" class="GINGER_SOFTWARE_mark">etc</gs>)

Thank you!

 

[James006]

Hi,

The easiest solution to get hours with a night shift is to use the mod() function ...

=mod(your calculation,1)*24

HTH