Traditional Culture Encyclopedia - Almanac inquiry - Calculating time in excel with vba
Calculating time in excel with vba
Function gettime(t)
Irregular
If VBA. Typename (t) = "string" and then tmp = time value(t) or tmp = t.
gettime = Format(tmp-Rnd * 20/24/60,“hh:mm“)
End function
Application mode
= gettime(“08:00“)
or
= gettime( 1 USD)
(Assume that B 1 is filled with 08:00.
- Previous article:Check in the old calendar 1966
- Next article:Gregorian calendar software score
- Related articles
- How to adjust the month of perpetual calendar?
- Dreaming that something happened to my parents.
- How many printing plants are there in Gutian, Qiaokou District, Wuhan?
- What is the meaning of the five elements earth tomb?
- Emerald bracelets are generally flat bracelets. How wide and thick is it?
- Will crying at Lantern Festival affect luck?
- Why do you wear red underwear to ward off evil spirits in this animal year?
- Member of the Board of Directors of Southeast University Alumni Association
- How did the ancients view time? Tell me more. . .
- Dream of clothes being scratched