View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Computing Time from One Day to Another

Try:

=((C1-A1)*8+(D1-B1)*24)*60

Format as general

A1=Start Date
B1=Start Time
C1=Finish Date
D1=Finish time

HTH


"Wendy" wrote:

I need to find the length of time it takes a process to be completed from
start to finish. But its based on a an eight hour work day. For example:
Starts on 07/25/07 at 8:00 am finishes at 9:00 am on 07/27/07. I am
scheudled to work form 8 to 4 each day. How many minutes did it take to
complete
--
Thank You, Wendy