Time sheet convertions

I" creating a payroll timesheet for work here.

I have it so all calculations are correct and it does what I need, But I need to make it easier for the gal who will be doing payroll.

What I would like to try and do is fix where she puts in the times in and out.

Example:
She would put in the "in" time in D3 and the "out" time in F3
What I would like is to auto change the format.
So in D3 she types 830 and it automatically changes to 8:30
Or if she would type 8.30 change to 8:30?

Any way of doing that?

This might work for you. The ranges would need to be changed to suit your needs. If it is something you can work with and you need help; you only need to ask.

Dean

If you type 8:30 in D3 it will show 8:30 in Excel. Then type for instance 16:45 in F3 and then type =F3-D3 in cell in G3, and it will calculate to 8:15.

Now the interesting thing is that the time format in Excel is actually a decimal number. It is only shown as a time. The decimal number is the fraction of 24. 8:15 is 8.25/24 = 0.34375. So if you change the format of the cell which says 8:15 to General, you will see that it actually is 0.34375.

I hope this helps
Ola Sandström

Thanks Dean

Works Almost perfect.

I have changed to the cells I need and changed the format of the cell and all works and still calculate the way I want.

But

When I protect the worksheet from anyone editing it throws a 1004 debuging error then breaks. I have to reopen then put the code back in.
Any ideas how I can still have your code and lock the sheet so it doesn't error out

Got that figured out.

Protection --> Format Cells

Checked that and all works as it should.

I do have one more question on saving this sheet.

I use excel 2007 and it has me saving the file as *.xltm
but the work computers are excel 2000.

Best way to save?

Look at the choices in the drop-down in the Save As dialog.

Glad you got everything worked out and thanks for the feedback.

Dean