If you are entering the times right into a worksheet, go to the DATA menu
and try VALIDATION... or format the field to the time format you like.
You must enter the time as an hour and minute separated by a ':'.
8: however, will enter as 8:00.

If you are entering the times into a userform, there are a couple options.
"Peekabeaux" wrote:

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