View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default adding hours and minutes to a time value.

Hi Joe,

Am Mon, 1 Oct 2012 10:57:01 -0700 (PDT) schrieb Joe Solsbee:

Start Time 12:30
Units Scheduled Run Time Finish Time
Product Code 28597 4500 1.50


if the run time is in hours, then:
start time + run time / 24


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2