remember that Excel saves time internally as teh decimal part of a day. So
6AM is 0.25 and 12 noon is 0.5
One check for times that roll to the next day would be to add '1' if the end
time is earlier than the start time....1 of course is in Excel terms, 1 day,
thus 24 hours.

"PJF" wrote:

P.S. CAUTION: This will only work for shifts that do not cross midnight. If
you have an 11 PM to 7 AM shift, this won't work. Will see if I can come up
with a solution.


"PJF" wrote in message
...
Here's a crude way: Use 24-hour (Military) time to enter the start and
end
times. Be sure to insert a colon between hours and minutes. So, if an
employee works 7AM to 3:30 PM, the entries would be 7:00 and 15:30,
respectively. You can format the cells so that they display English time,
i.e., 7:00 AM and 3:30 PM, respectively. So, if you put the start time in
cell A1 and the end time in A2, you can use a simple subtraction formula
in
cell A3, formatting it as a simple number. It will display as a decimal.
You must multiply the decimal by 24 in order to get a display of hours
worked.

So, the employee inserts :

08:00 in cell A1 and will display as 8:00 AM
15:30 in cell A2 and will display as 3:30 PM

The total time worked is then calculated in A3 by the formula: =(A2-A1)*24
and will display as 7.5. If you'd rather retain a time display in A3
(7:30), change the format and delete the 24-hour multiplier.

Hope this helps.




"Peekabeaux" wrote in message
...
I am attempting to create a time card in which the user just types in
the
time they clock out and type in the time they clock out. At the end of
the
day I want to total number of hours worked. But when I use a time
format,
and enter 8 for 8:00 a.m, the value shows 1/8/1900 at 12:00 a.m.. How
do
I
fix this so only the hours and minutes are shown and I can calculate the
daily and weekly totals? I have tried downloading 2 different templates
from
Microsoft, but still shows the date. Please help.
Oh yeah, while I'm asking :-), does anyone out there know how to insert
a
cell value in a header. I want to apply this to a template.
Thanks,

Peek