Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating times
I have two columns. One which calculates the length of time a job will take
to run on a machine, and the other in which we put the time the job will come off the machine. At present we enter the time off manually. Is it possible to calculate the time off automatically (to the nearest 1/4 of an hour) if we put in a start time ? Thanks |
#2
|
|||
|
|||
Assuming that the start time is in A2, job time in B2, and they are both
formatted as time, just use =ROUND((A2+B2)*96,0)/96 -- HTH RP (remove nothere from the email address if mailing direct) "gibbylinks" wrote in message ... I have two columns. One which calculates the length of time a job will take to run on a machine, and the other in which we put the time the job will come off the machine. At present we enter the time off manually. Is it possible to calculate the time off automatically (to the nearest 1/4 of an hour) if we put in a start time ? Thanks |
#3
|
|||
|
|||
Thanks for quick reply, but it's not that straight forward..... the value in
B2 at present is just a number i.e 2.3 meaning 2.3 hours in duration. Any tips ? "Bob Phillips" wrote: Assuming that the start time is in A2, job time in B2, and they are both formatted as time, just use =ROUND((A2+B2)*96,0)/96 -- HTH RP (remove nothere from the email address if mailing direct) "gibbylinks" wrote in message ... I have two columns. One which calculates the length of time a job will take to run on a machine, and the other in which we put the time the job will come off the machine. At present we enter the time off manually. Is it possible to calculate the time off automatically (to the nearest 1/4 of an hour) if we put in a start time ? Thanks |
#4
|
|||
|
|||
If A2 is still time (02:00:00) and B2 is 2.3, you could use:
=ROUND((A2+B2/24)*96,0)/96 (format as time) If both A2 and B2 are not times (just numbers like 2.3), you could use: =ROUND((A2/24+B2/24)*96,0)/96 or =ROUND((A2+B2)/24*96,0)/96 or =ROUND((A2+B2)*4,0)/96 gibbylinks wrote: Thanks for quick reply, but it's not that straight forward..... the value in B2 at present is just a number i.e 2.3 meaning 2.3 hours in duration. Any tips ? "Bob Phillips" wrote: Assuming that the start time is in A2, job time in B2, and they are both formatted as time, just use =ROUND((A2+B2)*96,0)/96 -- HTH RP (remove nothere from the email address if mailing direct) "gibbylinks" wrote in message ... I have two columns. One which calculates the length of time a job will take to run on a machine, and the other in which we put the time the job will come off the machine. At present we enter the time off manually. Is it possible to calculate the time off automatically (to the nearest 1/4 of an hour) if we put in a start time ? Thanks -- Dave Peterson |
#5
|
|||
|
|||
A2 is still time?
=ROUND((A2+B2/24)*96,0)/96 -- HTH RP (remove nothere from the email address if mailing direct) "gibbylinks" wrote in message ... Thanks for quick reply, but it's not that straight forward..... the value in B2 at present is just a number i.e 2.3 meaning 2.3 hours in duration. Any tips ? "Bob Phillips" wrote: Assuming that the start time is in A2, job time in B2, and they are both formatted as time, just use =ROUND((A2+B2)*96,0)/96 -- HTH RP (remove nothere from the email address if mailing direct) "gibbylinks" wrote in message ... I have two columns. One which calculates the length of time a job will take to run on a machine, and the other in which we put the time the job will come off the machine. At present we enter the time off manually. Is it possible to calculate the time off automatically (to the nearest 1/4 of an hour) if we put in a start time ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED HELP - Calculating dates and times | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |