Dear All,
I have the following sample Monthly OT Hour(Aggregated) which I need to covert as follows:-
Could somebody help me out with the formula pls?
Sample data set along with the desired results as follows:-
30:50:00=31:00
30:29:00=30:00
Regards
I have the following sample Monthly OT Hour(Aggregated) which I need to covert as follows:-
Could somebody help me out with the formula pls?
Sample data set along with the desired results as follows:-
30:50:00=31:00
30:29:00=30:00
Regards