Howdy I'm working on a spreadsheet for a department here to work out the number of hours in a day worked on a project but I've never been good working with time in excel. If anyone's able to help here's the requirements Start time - needs to be simple to input, preferable don't have to input colons End time - as above Breaks - a box for amount of minutes on breaks Hours worked - output figure ideally would be in minutes minus breaks Cheers
If you don't want users to muck about with colons when entering the time(s) then it's probably easier to separate the inputs for hours and minutes. Ideally you'd want a form for this but can do it just with direct entries into cells.
Oh, and you'll need some validation on the entries, so you can't enter an end time before the start time, or a minutes value greater than 59, and so on and so forth.
Including only numbers. Would you believe me if i told you someone tried to type "five" as their age on an old mockup I was doing.
The people that would be using it are the kind of people would let it break and tell no one and blame the creator, no matter of training would change them! I will try but only to prove it can be done.
One other thing I would do is to lock all the cells that don't need user entry and password protect the sheet. If you leave cells unlocked, people will screw up all your hard work.
Can you use VBA with your spreadsheet? If yes you can reduce time entry into a button press. I also it will surprise people how long their breaks really are as must people underestimate. I can provide example code tomorrow if you are interested.
If you go in say blocks of 10 or 15 minutes you can do the time entry as a drop down selection, one for hours and one for minutes. This gives you a very predictable entry format which will make the spreadsheet more robust.