Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Formula for agenda to create start/stop with projected time of ev | Setting up and Configuration of Excel | |||
i need to calculate the total time from a start time to and end t. | Excel Discussion (Misc queries) | |||
How can I get elapsed time between AM start/PM stop | Excel Worksheet Functions |