request for time interval worksheet function

Z

Zb Kornecki

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
 
J

Joel

Function TimeDiff(MyTime1 As Date, MyTime2 As Date)

TimeDiff = (MyTime2 - MyTime1) * 24

End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top