Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.

Thanks in advance.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default 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.

Thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.

Thanks in advance.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.


Thanks in advance.



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.


Thanks in advance.





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default 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)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 04:45 PM
template or formula for start time -finish time -total hours ple cc New Users to Excel 1 March 27th 06 06:06 PM
Formula for agenda to create start/stop with projected time of ev Dot Setting up and Configuration of Excel 0 March 9th 06 03:39 PM
i need to calculate the total time from a start time to and end t. Bob Excel Discussion (Misc queries) 1 February 22nd 05 05:54 PM
How can I get elapsed time between AM start/PM stop khacmac Excel Worksheet Functions 1 February 2nd 05 12:17 AM


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"