Adding military time.

**Aaron216** · 04-16-2008, 09:18 PM

I need help with a calculations for a spread sheet I’m working on to help track the end of run time for a production run.

I can get excel to do the first calculation (dividing 12,000 gallons by 690 gallon per hour) and come up with the 17.39 hours left in a run, but what I want excel to do next is to add 17.39 hours to the current time of 13:46 and give me the end of run time which would be 06:09.

I am a total noob at excel and I am a mere blue collar worker trying to make things easy on myself.

**Paul** · 04-16-2008, 11:43 PM

Hi Aaron,

Please Login or Register  to view this content.

Where A1 holds your start time.

If your 12000 or 690 values change, or are stored in cells, put those cell references into the formula instead of the hard values.

13:46 is actually a number in Excel, formatted to look like time. It's equivalent to .573611 days (1 day = 86400 seconds). To add 17.39 hours, you determine how many seconds that is and divide it by 86400. This returns a decimal value to add to the start value.

PS - 13:46 + 17.39 hours is 7:09, not 6:09.

Adding military time.

LinkBack

Thread Tools

Rate This Thread

Display

Adding military time.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions