Horticulturist Doing Excel

E

emul

Ok, I've got a small excel background, small landscape business, an
trying to set stuff up in excel.

Found this forum looks awsome!

My question is two.

1. How would I set up a time sheet formula sheet, where you can ente
in a start time in hours and minutes, and then find total hours worked
I can't seem to figure it out by inputing hours and minutes.

2. How would I get the top cell row with all my account names to follo
me all the way down the worksheet. I can't tell what category I'm typin
into way down the worksheet and its's a pain to scroll all the way bac
to the top. There's got to be a better way...

Thanks for the help!
 
F

Frank Kabel

Hi
1. Question:
- in A1 enter your starting time in the format hh:mm (e.g. 08:00)
- in B1 enter your ending time (e.g. 20:00)
- now in C1 use the formula
=B1-A1
and format this as time (menu 'Format - Cells')
If your time range can span midnight use the following formula instead:
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)

2. Question:
- move the cursor in the cell BELOW your heading row. e.g. in cell A2
- goto the menu 'Windows - Freeze Panes'
 
Top