Forum Discussion
Solved
Need Help for Overtime Calculation in duel shift
if anyone understand what i want then please help. thanks
I am still not sure what you require.
I have assumed you want to enter the clock times as a decimal number and I have used DOLLARDE to convert a time expressed as an integer part and a fraction part of an hour in 60ths, such as 1.30, into a time expressed as a decimal part of a day which displays as 1:30 AM or 1:30 PM (that is 1.5 hours).
This should take a time expressed as a decimal number with the point separating hours and minutes and interpret it as a PM time.
= (12 + DOLLARDE(nightStart, 60)) / 24
so
8.30
becomes
8:30 PM
Really appreciate your valuable reply, how can i share the excel sheet for better solution. because i'm not able to create the final sheet yet