I want to create a time card in excel (2003).
4 time fields (Time in morning, Time out lunch. Time in after lunch, Time
out end of day)
The next field (column) needs to be able to total the actually hours worked.
Needs to be able to deal with hours & minutes.
I might even want to put a button that will "stamp" the current time in one
of the above fields.
Any help here will be appreciated.
Thanks in advance
dave
T. Valko - 04 Jan 2008 04:01 GMT
See this:
http://j-walk.com/ss/excel/files/timesht.htm

Signature
Biff
Microsoft Excel MVP
>I want to create a time card in excel (2003).
> 4 time fields (Time in morning, Time out lunch. Time in after lunch, Time
[quoted text clipped - 10 lines]
> Thanks in advance
> dave
Dave - 04 Jan 2008 16:10 GMT
That looks like it might work for me.
Looks like the math was simpler then I thought.
Thanks much
dave
> I want to create a time card in excel (2003).
> 4 time fields (Time in morning, Time out lunch. Time in after lunch, Time
[quoted text clipped - 10 lines]
> Thanks in advance
> dave
T. Valko - 04 Jan 2008 19:03 GMT
You're welcome!

Signature
Biff
Microsoft Excel MVP
> That looks like it might work for me.
> Looks like the math was simpler then I thought.
[quoted text clipped - 17 lines]
>> Thanks in advance
>> dave