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
|