View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan Bickett Jonathan  Bickett is offline
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.