Tutuorial on creating a time sheet needed

[Debutante]

I am an expert user of Excel..except when it comes to complicated formulas.
I am trying to create a worksheet that will allow me to add a time period
and then have the time calculated.

ie) Time worked 4:00-4:30 = .30

Is anyone aware of any tutorials on this (free or not)..I have googled and
only come up with software that produces Excel spreadsheets..not necessarily
any how-to's.

Thank you.

 

[Gord Dibben]

Deb

Chip Pearson has a good site with examples and instructions for computing time
worked and overtime.

Also an example workbook to download.

Not sure if he addresses weekends or not, but have a look.

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

Gord Dibben Excel MVP

 

[Debutante]

Great..thank you so much.

Deb

Chip Pearson has a good site with examples and instructions for computing time
worked and overtime.

Also an example workbook to download.

Not sure if he addresses weekends or not, but have a look.

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

Gord Dibben Excel MVP