UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Can't Calculate ETA (Time) with Hours    
 
   
ajames420
post Aug 23 2007, 11:04 AM
Post #1

UtterAccess Veteran
Posts: 473
From: Milwaukee, WI Area
I have spreadsheet the the user's click a button a form opens and they enter the data.
After they append the data to the spreadsheet I am trying to calculate times

For example: 13:00 + 6 (Hours to sort) Estimated time to finish = 19:00

It keeps coming up with the Start time of 13:00

Please see spreadsheet.

Thanks
Attached File(s)
Attached File  FruitSchedules.zip ( 17.13K ) Number of downloads: 5
 
Go to the top of the page
 
+
Clippit
post Aug 23 2007, 12:09 PM
Post #2

UtterAccess VIP
Posts: 3,645
From: Near Toronto, ON, CA
Change the formula in G4 to:
=E4+(H4/24)

It's treating your hours to add as days, so you should divide by 24. This is because Excel stores dates as numbers. See this page for some background on how Excel works with date/time values.
Go to the top of the page
 
+
norie
post Aug 23 2007, 12:21 PM
Post #3

UtterAccess VIP
Posts: 4,308
Here's another formula.

=TIME(HOUR(E4)+H4,0,0)
Go to the top of the page
 
+
ajames420
post Aug 23 2007, 12:22 PM
Post #4

UtterAccess Veteran
Posts: 473
From: Milwaukee, WI Area
Steve,

Thank you very much. That helps greatly.

Have a great day.
Go to the top of the page
 
+
ajames420
post Aug 23 2007, 12:25 PM
Post #5

UtterAccess Veteran
Posts: 473
From: Milwaukee, WI Area
Norie,

Thank you as well. I think Steve's formula will work better for me as it calulates down to minutes which is what I was looking for.


To much info is always good for reference.
Go to the top of the page
 
+
Clippit
post Aug 23 2007, 02:01 PM
Post #6

UtterAccess VIP
Posts: 3,645
From: Near Toronto, ON, CA
You're welcome!
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 09:14 PM