ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help making a time card (https://www.excelbanter.com/excel-discussion-misc-queries/191864-help-making-time-card.html)

Lisa[_4_]

Help making a time card
 
I am trying to make a time card for work- there maybe one on line already but
I haven't looked. What I need help with is how do I format the cell where it
adds up how many hours you worked that day. Example, first cell has you came
in at 8 am, next cell you left at 5, now how do I make the next cell
calculate you worked 8 hours.?

FSt1

Help making a time card
 
hi
try looking here.....
http://www.cpearson.com/excel/overtime.htm
and here...
http://j-walk.com/ss/excel/files/timesht.htm

regards
FSt1

"Lisa" wrote:

I am trying to make a time card for work- there maybe one on line already but
I haven't looked. What I need help with is how do I format the cell where it
adds up how many hours you worked that day. Example, first cell has you came
in at 8 am, next cell you left at 5, now how do I make the next cell
calculate you worked 8 hours.?



All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com