[tkmd]

Im having problems again in excel. I'm trying to make a pay roll sheet where in one cell I want to put hours worked. So for example, 1PM to 2PM. I want excel to note that this is one hour. How in the world do I do this?

I've tried designating the cell as a "time " value and using the notation "1:00 PM - 2:00 PM" but am still getting an error in the summation cell as "#value!" what am doing wrong?

[Ω]

Why not use two cells? One for the start time and then one for the finish time.

Then use a simple finish - start = hours worked. You will also have to make allowances for swapping between AM to PM and vice-versa.

As for the time format I found this to be nothing more than an annoyance and use decimal instead where .5 represents half past.

HTH