Forum Discussion
Return earlies and latest time
Hello, I'm trying to make a an excel time sheet (see attached). The first sheet is what a manager would use to put in hours and the second sheet is a summary of the first sheet for employees to use....
Which format of record shall be in Sheet2 for such case, e.g. 8pm to 12am for one day and 12am to 4am for next day (and what if next shift is at 8pm same date); or just 8pm to 4am; or what?
And on which Excel version / platform you are?