Hi All,
First of all, if this question has already been posted and answered, I apologize, but I couldn't find the answer. Please feel free to point me in the right direction.
On the off chance that this hasn't been addressed I attached the appropriate file (abbreviated version only as it is normally about 2,500 lines). This is a system generated punch report that has the date and time in each cell. Although calculating the total time worked is simple enough, when a time period rolls over midnight I do not know how to calculate the time worked before and after midnight.
Thanks in advance for your help, it is very much appreciated.
First of all, if this question has already been posted and answered, I apologize, but I couldn't find the answer. Please feel free to point me in the right direction.
On the off chance that this hasn't been addressed I attached the appropriate file (abbreviated version only as it is normally about 2,500 lines). This is a system generated punch report that has the date and time in each cell. Although calculating the total time worked is simple enough, when a time period rolls over midnight I do not know how to calculate the time worked before and after midnight.
Thanks in advance for your help, it is very much appreciated.
