In the database we have a field that stores time as minutes from midnight, in crystal i need to convert this from minutes from midnight to a time i.e. 480 minutes from midnight is 08:00, then i have a finish time of 960, i also have a start time for break of 720 and a end time for break of 738.
Their is a field that says what's the start and finish which are as follows:-
1 is start
3 is start break
4 is end break
2 is finish
Now after i've converted these minutes from midnights into times i need to find the time diffrence.
My main goal is to find how many hours are worked in the week.