Hi everyone!
I'm trying to create a spreadsheet that creates a work schedule. Names are vertical down and days of week with clock in and clock out underneath are horizontal across.
I'd like to use time formating of 12:00 AM for both clock in and clock out as we are running a 24 hour operation with employees coming and going at all times. What I am struggling with is being able to quickly and easily enter times for multiple employees without having to type 1-2-:-0-0- -A-M. Any solution to this? I'd also like to total up the hours for the week and then mulitply the hours by the wage rate. I've never used time formatting before and any help would be greatly appreciated. I'm mildly dangerous with Excel - I understand a lot and use many different functions, but not much about some of the less commonly used functions. Any help is greatly appreciated!!!
Thanks,
Patt
I'm trying to create a spreadsheet that creates a work schedule. Names are vertical down and days of week with clock in and clock out underneath are horizontal across.
I'd like to use time formating of 12:00 AM for both clock in and clock out as we are running a 24 hour operation with employees coming and going at all times. What I am struggling with is being able to quickly and easily enter times for multiple employees without having to type 1-2-:-0-0- -A-M. Any solution to this? I'd also like to total up the hours for the week and then mulitply the hours by the wage rate. I've never used time formatting before and any help would be greatly appreciated. I'm mildly dangerous with Excel - I understand a lot and use many different functions, but not much about some of the less commonly used functions. Any help is greatly appreciated!!!
Thanks,
Patt