how can i set up a timesheet in excel

B

Bez

I am trying to set up a timesheet in xcel but am having trouble getting a
negative number to appear (in case people work less than the requisite number
of hours)
 
H

Harald Staff

Hi

That can only be done with the calendarformat set to "1904" (the Mac
standard), found somewhere in the Tools > Options menu.

HTH. Best wishes Harald
 
D

dcraig

I found if you multiply each time * 24 and calculate the difference, format
the answer as general, it will give you the number of hours. You can then
have negative hours without problems.

C67 D67 E67 F67 G67
7:30 AM 12:00 PM 1:00 PM 4:00 PM 7.5

G67 =F67*24-E67*24+D67*24-C67*24

then 7.5 - 8 = -0.5

dcraig
 
Top