Only supposed to log 60mph - can't get there early!

  • Thread starter Thread starter Lady18wheeler
  • Start date Start date
L

Lady18wheeler

I drive a truck (cross country) from terminal to terminal. My truck
will go 72mph, but the company speed limit is 60mph. Among other
information I want my spreadsheet to figure for me, I want it to tell
me the earliest possible time I can get to my destination without
violating the company speed limit.

In (D2) I enter the miles. (F2)=D2/60. So if I enter 2700 miles, it
takes 45 hours to get there @ 60mph. (F2)=45.

(H2)=NOW() or 10/18. (H3)=NOW() or 4:07 PM. This is the date and
time I am leaving terminal 1 - I am starting my trip now.

Somebody please tell me how I can add 45 hours to "NOW()" so that (J2)
will show 10/20, and (J3) will show 1:07 PM.

NOW() is so easy and convenient, but I can type in the date and time if
necessary.

(J2)'s heading is "Can't get there before..."
(J3)'s heading is "... at this time."

Any suggestions, comments, advice, etc. are appreciated.
 
In J2: =H2+F2/24- format as date
In J3: =H3+F2/24 - format as time

But why not just have H2 formatted as date and time and forget H3, then J2
would be the same formula as above formatted as date and time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Don't use now() since it will change with each calculation, insert the date
in H2 by pressing ctrl + ;
insert time in H3 by pressing ctrl + shift + ; Now to get the date you'll
arrive

=H2+H3+45/24

if you want to use NOW you can use it in H2 only since it returns the date
and time and maybe it makes sense to have a value that changes.

so if you are using now in H2 this formula will return 45 hours plus

=H2+45/24
 
Oops!

Replace 45 with the cell reference (D2)

--

Regards,

Peo Sjoblom

Peo Sjoblom said:
Don't use now() since it will change with each calculation, insert the date
in H2 by pressing ctrl + ;
insert time in H3 by pressing ctrl + shift + ; Now to get the date you'll
arrive

=H2+H3+45/24

if you want to use NOW you can use it in H2 only since it returns the date
and time and maybe it makes sense to have a value that changes.

so if you are using now in H2 this formula will return 45 hours plus

=H2+45/24
Click to expand...
 
How can I format H2 as date and time? My options under the Format menu
are one or the other - I don't see anything that will let me combine
the two.
 
Back
Top