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


"Zb Kornecki" wrote:

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