How to do math on time

[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
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]

See this:

http://j-walk.com/ss/excel/files/timesht.htm

 

[Dave]

That looks like it might work for me.
Looks like the math was simpler then I thought.

Thanks much

dave

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

That looks like it might work for me.
Looks like the math was simpler then I thought.

Thanks much

dave