I am getting a report with a number of differences, for example the fields below
3 days 4 hours 15 minutes
6 hours 12 minutes
1 hour 15 minutes
and there are many grouped classes ... I freely want the amount of time for each section.
The above can be solved by changing the seconds in seconds and adding them.
There is a function, then change the total number of seconds in days / hours / minutes and seconds.
The function DHMS (Date as date 1, Date as date 2), long as long as the blurred number of string number number as long as the blurred number Number of seconds between number of numbers as long as number of numbers in the form of mist number 'numeraphsenk = abs (datfif ("s", dated 1, dated 2)), calculate the day and the remaining second numberof number = off Calculate the seconds \ 86400 numbersofficeconds = numberoffsand mod 86400 'hours and calculate the remaining Nds numberoffores = numberOffersCandes \ 3600 numbersofficeconds = numberAllcodesCode 3600Counts' minutes and seconds remainingOffFonts = numberOfficeContents \ 60 numbersOfficeScands = numberAfficeCandAd 60' time remaining DHMS = Numberofdocumentation and return; "Day" & amp; _IIf (numberoff = 1, "", "s") & amp; _ Numberoffhors & amp; "Bell" & amp; _ IIf (numberoffhors = 1, "", "S") & amp; _ Number of minutes and amp; "Minutes" & amp; _IIF (numberfimits = 1, "", "S") & amp; _ Number offsands & amp; "Second" & amp; _ IIf (numberoffscondus = 1, "", "S") termination function
Comments
Post a Comment