Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
Formula to find Stop Time from Start Time and Total Minutes

I have a work sheet with start times (all in military time) and total
minutes (in the format of 120 = 2 hours). I need to figure out what
the stop times would be.

For example:

Start time: 08:00:00
Total minute: 180 minutes

The stop time would be 11:00:00, but I cannot figure out a formula to
calculate this. There are obviously much more complex start times and
total minutes that will make this a chore if I cannot find a solution.

#2
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 4,624
Formula to find Stop Time from Start Time and Total Minutes

XL stores times as fractional days (i.e., 1.0 = 1 day = 24 hours = 1440
minutes = 6400 seconds), so

A1: 08:00:00
A2: 180

A3: =A1+A2/1440

Format A3 as a time.

In article om,
"Jonathan Bickett" wrote:

I have a work sheet with start times (all in military time) and total
minutes (in the format of 120 = 2 hours). I need to figure out what
the stop times would be.

For example:

Start time: 08:00:00
Total minute: 180 minutes

The stop time would be 11:00:00, but I cannot figure out a formula to
calculate this. There are obviously much more complex start times and
total minutes that will make this a chore if I cannot find a solution.

#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 8,651
Formula to find Stop Time from Start Time and Total Minutes

=A1+B1/(24*60) and format the result as time.
--
David Biddulph

"Jonathan Bickett" wrote in message
ps.com...
I have a work sheet with start times (all in military time) and total
minutes (in the format of 120 = 2 hours). I need to figure out what
the stop times would be.

For example:

Start time: 08:00:00
Total minute: 180 minutes

The stop time would be 11:00:00, but I cannot figure out a formula to
calculate this. There are obviously much more complex start times and
total minutes that will make this a chore if I cannot find a solution.

#4
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
Formula to find Stop Time from Start Time and Total Minutes

Ah! So simple. Thanks so much for your help...you are awesome.

On Mar 7, 11:55 am, JE McGimpsey wrote:
XL stores times as fractional days (i.e., 1.0 = 1 day = 24 hours = 1440
minutes = 6400 seconds), so

A1: 08:00:00
A2: 180

A3: =A1+A2/1440

Format A3 as a time.

In article om,
"Jonathan Bickett" wrote:

I have a work sheet with start times (all in military time) and total
minutes (in the format of 120 = 2 hours). I need to figure out what
the stop times would be.

For example:

Start time: 08:00:00
Total minute: 180 minutes

The stop time would be 11:00:00, but I cannot figure out a formula to
calculate this. There are obviously much more complex start times and
total minutes that will make this a chore if I cannot find a solution.

#5
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
Formula to find Stop Time from Start Time and Total Minutes

This works great as well. Thank you for your help!

On Mar 7, 12:01 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=A1+B1/(24*60) and format the result as time.
--
David Biddulph

"Jonathan Bickett" wrote in message

ps.com...

I have a work sheet with start times (all in military time) and total
minutes (in the format of 120 = 2 hours). I need to figure out what
the stop times would be.

For example:

Start time: 08:00:00
Total minute: 180 minutes

The stop time would be 11:00:00, but I cannot figure out a formula to
calculate this. There are obviously much more complex start times and
total minutes that will make this a chore if I cannot find a solution.

#6
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 4,624
Formula to find Stop Time from Start Time and Total Minutes

86400 seconds...

In article ,
JE McGimpsey wrote:

i.e., 1.0 = 1 day = 24 hours = 1440 minutes = 6400 seconds)

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Lindsay Excel Worksheet Functions 13 November 8th 06 04:45 PM cc New Users to Excel 1 March 27th 06 06:06 PM Dot Setting up and Configuration of Excel 0 March 9th 06 03:39 PM Bob Excel Discussion (Misc queries) 1 February 22nd 05 05:54 PM khacmac Excel Worksheet Functions 1 February 2nd 05 12:17 AM

All times are GMT +1. The time now is 06:28 AM.