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).
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).
it's working now, thanks for your great support.