View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
luvmath03
 
Posts: n/a
Default Some help needed?


I am not sure whether to post this here or in programming.

I am trying to add a various amounts of minutes to a time. The problem
is the format of the time. It is given increments of 10 minutes from 8
hours before something to 7 hours after.

Examples:


8 hours before ...+....22 minutes......7hours 38minutes before
7hours 50 min ...+....21 minutes......7hours 29minutes before
1hour 15minute....+...105minutes......0 hours 30minutes after

6hours 30min after...+..35 minutes......5minutes before

etc. Can someone help?


--
luvmath03
------------------------------------------------------------------------
luvmath03's Profile: http://www.excelforum.com/member.php...o&userid=33123
View this thread: http://www.excelforum.com/showthread...hreadid=529339