Quote Originally Posted by kryptic View Post
Thanks very much. Now I am not able to calculate the number of hours worked from Shift Start and Shift End fields. If the Shift Start is 5:25 PM and Shift End is 4:15 AM, then I should be able to get 8.83 Hrs or 8 Hrs 50 Mins so that I can calculate the amount per hour.
5:25 PM to 4:15 AM is 10hrs 50mins.

=MOD(end-start,1) formatted as h:mm = 10:50

=MOD(end-start,1)*24 formatted as General or Number = 10.8333333333

Is there anyway I can change the code so that when I type in Shift Start, I should get PM only? I tend to type 5 instead of 17 as it is on paper but typing 5 gives me AM. As I quickly type, I cannot think and type whatever is on the paper.
You can probably do that but I'm not much of a programmer and I don't know how to do it.