We are using the Aloha POS in our restaurant. The POS has a time clock
funtion as part of the operating system. Each employee clocks in and out for
their shift worked. Aloha stores all the punches for each employee in our 24
hour restaurant. At the end of the pay period I export a Coconut Code file
(.txt ) out to a Excel work book. This workbook will calcuate the hours
worked for each shift and give the total hours worked for the pay period in a
transmittal form to our accountant. The problem I am having. I have not been
able to write a formula that checks and calculates the hours worked for the
employess that work the overnight shift. Example : Clock in at 23:00 and
Clock out at 06:00. The hours worked should be 7:00. Excel gives me a #######
error because it is giving a negative time. This formula should be able to
work on all the times not just the overnight times.