Display / Store time that is greater than 24 hours - Microsoft Community


i creating form calculate run time subtracting end time start time. 

i using macros visual basic scripting non-existent , if necessary want other people able modify script in future.

in macro have following:

item= [forms]![jobs]![calculated run time]

expression= [forms]![jobs]![end time]-[forms]![jobs]![start time]

if calculate run time of 01/11/2017 01:30:00 - 01/10/2017 01:00:00 value of 00:30:00 instead of 24:30:00.

how can set can 24:30:00?

unlike excel, access has no cumulative time format. display time decimal hours:

expression= 24*([forms]![jobs]![end time]-[forms]![jobs]![start time])

format calculated run time text box general number, or fixed desired number of decimal places.



Office / Access / Other/unknown / Office 2013



Comments

Post a Comment

Popular posts from this blog

Windows 10 does not have any of my previous Windows 7 email address. - Microsoft Community

in windows 10, go edge , type in hotmail.com , windows 7 information including 30 address there. windows 10 email not have these addresses can not forward new emails previous list of email address wish forward to. ***post moved moderator appropriate forum category.*** hi, in regards concern, when sign account access product, create record of sign in. if sign third-party service microsoft account, asked consent share account data required service. if want remove or delete collected data or stored microsoft edge, please follow steps below: in microsoft edge, go more and click on settings . under clear browsing data , select choose clear . check boxes next data type you’d clear, select clear . if you’d like, turn on setting below check boxes always clear when close browser . here's additional information microsoft edge, browsing data, , privacy . hope above information he
Read more