- I am creating timer for casual work, but after I can't find a place to see them back as a report or anything?
Original Post
Replies sorted oldest to newest
Dim a, i, j, hh, nn, ss a = "Duration: " i = InStr({NOTES.Text}, a) + Len(a) j = InStr(i, {NOTES.Text}, ":") hh = Mid({NOTES.Text}, i, j - i) i = j + 1 nn = Mid({NOTES.Text}, i, 2) i = i + 3 ss = Mid({NOTES.Text}, i, 2) formula = (Val(hh)*3600) + (Val(nn)*60) + Val(ss)