request for time interval worksheet function

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

Guest

I create workbooks that measure multiple different intervals from over 30
different time stamps. I now calculate the interval manually typing in
formulas for subtracing dates and multpling to get the correct unit etc. I
was hoping someone has or would consider writing a worksheet function that
measures time intervals and will return either total minutes, hours and
minutes or decimal hours (1.25 hours). his wouls save me much time.
thank-you Zb
 
Function TimeDiff(MyTime1 As Date, MyTime2 As Date)

TimeDiff = (MyTime2 - MyTime1) * 24

End Function
 
Back
Top