Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Programming

Aug 30, 2004 10:39AM PDT

I'm intrested in making an employee schedule in excel. My question is, is there a way to get excel to recognise 12-6 or 1-9 as 6 or 8 hour shifts and automatically calculate and total them?

Discussion is locked

- Collapse -
Re: Excel Programming
Aug 30, 2004 8:37PM PDT

Try the vlookup-function to translate a code to something else (in this case a number). Or write a lot of Visual Basic code. But I think the first is easier.

Kees

- Collapse -
Re: Excel Programming
Sep 7, 2004 2:15AM PDT

Please describe your problem exactly, like how do you make sure that an employee "punched in" a card at that particular time. Or do you have a time keeper in your company who will keep track of the time-in and time-out of the employees? How do you plan your employee schedule to look like? I can write some code that will constantly check the system time for a specific time.