I would like to do this permanently to the template, so that I have
timesheets that I don't hav eto change everytime I input my time data. Thx
I would like to do this permanently to the template, so that I have
timesheets that I don't hav eto change everytime I input my time data. Thx
The question is not clear so here are some suggestions
B1: =A1-0.5
A1: 11:00 PM ---> B1: 11:00 AM
=IF(A1>0.5,A1-0.5,A1)
Menu:Data>Validation... Allow:Time, Data:Less then or Equal to, End time: 12:00
Hope it helped
Ola Sandström
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks