Excel timesheet

[Stemar1]

Can I subtract 2 times to equal time worked (i.e. timesheet) in Excel

 

[Jason Morin]

You should be able to just subtract the 2 values. MVP
Chip Pearson has an example timesheet on this site:

http://www.cpearson.com/excel/overtime.htm

HTH
Jason
Atlanta, GA

 

[Guest]

-----Original Message-----
Can I subtract 2 times to equal time worked (i.e. timesheet) in Excel
.

You just have to use the customs format. Right click on a
cell, do Format Cells and then in the NUMBER tablet, click
on custom and choose this format " [h]:mm:ss " and you<ll
be able to add uo your hours. You can change this format
by changing the TYPE (like [h]:mm will only give you the
hour and minuts )