How do I add times for a night shift i.e., 7:00 PM to 7:00AM.
B Biff Mar 18, 2005 #2 Hi! A1 = start time - 7:00 PM B1 = end time - 7:00 AM =B1-A1+(A1>B1) Format as h:mm = 12:00 =(B1-A1+(A1>B1))*24 Format as GENERAL = 12 Biff
Hi! A1 = start time - 7:00 PM B1 = end time - 7:00 AM =B1-A1+(A1>B1) Format as h:mm = 12:00 =(B1-A1+(A1>B1))*24 Format as GENERAL = 12 Biff
