Originally Posted by
Richard Buttrey
Hi,
I'd advise that you capture your times with a time format that excel can calculate. At the moment you're entering text which is not very useful and doesn't lend itself to easy analysis.
First decide whether you want users to enter hours and minutes or hours and decimals of an hour. i.e. 8:30 or 8.5 and create cells for both start & finish times.
Assuming you choose hours & minutes then use cell data validation and set the minimum and maximum times, (could be 0:00 to 23:59) or any other control you want, then you can prevent someone entering an invalid time.
Once you have proper time 'numbers' then you can use these in calculations.
Regards
Bookmarks