Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel formula and Time...
Hi everyone, I'm looking to create an excel sheet which when someone inputs a start time eg: 09:00, time for lunch: 1 hour, and length of shift: 7 hours, it throws up the time they are due to finish ie: 17:00 - I know this is relatively straight forward to work out in your head, but we have a lot of new starters and a vast array of shifts and lunchtime options so thought this would be a useful tool... How do I go about setting up such a spreadsheet? Thanks in advance... Neil -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554029 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel formula and Time...
=A1+(B1+C1)/24
where A1 is the start time, B1 the lunch hour value, C1 the shift hours -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "neilcarden" wrote in message ... Hi everyone, I'm looking to create an excel sheet which when someone inputs a start time eg: 09:00, time for lunch: 1 hour, and length of shift: 7 hours, it throws up the time they are due to finish ie: 17:00 - I know this is relatively straight forward to work out in your head, but we have a lot of new starters and a vast array of shifts and lunchtime options so thought this would be a useful tool... How do I go about setting up such a spreadsheet? Thanks in advance... Neil -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554029 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel formula and Time...
Hi Neil, This is easiest if you keep to entering times as hours and minutes rather than trying to be lazy and entering them as decimals. Excel will recognise times when you enter them in the 00:00 format. So to get a sheet to add times from a start time of 09:00, all you do is enter this time (don't forget the colon that indicates hours*:*minutes) in a cell, enter the hours (and minutes) next into the next column (eg 01:30 for an hour and one half for lunch). The next cell is for the number of hours in the day (07:00) and finally add all these up should result in 17:00 Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=554029 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Excel formula and Time...
Excellent - I thought it would be easier than I thought it would be. Cheers Neil -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554029 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I write an Excel formula to calculate my working time? | Excel Worksheet Functions | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |