Greetings All - I'm needing a little help with a field displaying 575:00:00. I've tried formatting as hh:nn:ss
Greetings All - I'm needing a little help with a field displaying 575:00:00. I've tried formatting as hh:nn:ss
hh:nn:ss is to format clock time, not elapsed time.
575:00:00 is not a clock time. That looks like a text string for elapsed time, in which case date formatting is futile because it is not a date/time value. Elapsed time should be saved as a double number type (or save start and end date/time and calculate difference). Then will require code to convert to the string 575:00:00.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I changed the format to double number and now it displays properly. How would I use that field with another to have a calculated percentage? For example... 575:00:00 is what percentage of 627:53:08?
Are you saying you changed field data type and the value is now stored as 575 and formatting displays it as 575:00:00? How do you do that?
Format property does not alter the original data. Just do calcs.
Format function results in a string.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, I didn't catch that... I had it formatted as text instead of a double number. Now my dilemma is that I have Total Hours as a double number (575:00:00 displays as 2070000), and another field which is the number of seconds in a day (86400). How can I show the difference in time so it'll display as 575:00:00? Right now if I did a calculated field and divided Total Hours by Seconds in a Day it displays 23:00 (formatted as short time). In Excel, it would display as 575:00:00 using the following format: [h]:mm:ss.
See post 9 in https://www.accessforums.net/access/...ime-38266.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.