Computing Time from One Day to Another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try:

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

Format as general

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

HTH
 
Back
Top