Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
? Format(#01:50# + #10:20# + #02:30#, "Short Time")
14:40
WorkingTime
12:45
1:20
4:16
14:44
12:12
16:23
18:19
21:12
TotTim
5:11
SELECT Sum(CDate([WorkingTime])) AS TotTim
FROM tblWrkTime
WITH OWNERACCESS OPTION;
4.21597222222
[code]
without the formatting
The "4." portion represents the four(4) days, while the ".2159 ..." portion represents the 5 Hours and a few (11?) minutes, as seen via:
[code]
? Format(4.21597222222, "Short Time")
05:11