If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exsessive time format
Using Access2000. Have a need for a form (I can have it refresh every 5,10
secs or so) that works like a report, no editing or data entry just requerys and requerys while it is open. The issue is that I need to time format in hours (and yes greater than 24), minutes, seconds. Found a formula that works great in a report but as I'm live monitoring the results and need to refresh every 5,10 secs or so, a report won't work. The formula in the report control is as follows =[SumOfTimeField]\3600 & Format(([SumOfTimeField] Mod 3600)/86400,"nn:ss") Same formula in the form control gives me an #ERROR# result. Changed the formula to =Sum([SumOfTimeField]\3600) & Format((Sum([SumOfTimeField] Mod 3600)/86400),"nn:ss") And got the right format to showbut received the same results for all 4 of the records on the form(it added them all up and that result then went to the field for each of the records.) The field [TimeField] is a number field measuring seconds from the beginning of the day. My result set sums that field (with criteria that would give me 4 subsets of totals) with other calculations to determine length of time. For example if I'm measureing logon time for 30 employees need to have results in hours:minutes:seconds without any days. Need to see the unique results for each record on the form. The underlying query used for the form is showing the correct data and if I select the data without formating I get the results just fine. Just need to format the results to the hours:minutes:seconds. HHHEEEEELLLLLLLPPPPPPP ( I believe in primal scream therapy ) :-) |
#2
|
|||
|
|||
Exsessive time format
Answered my own question. The formula below works fine as long as the name
property is not the same as the field name being formatted. DUHH "RWG" wrote: Using Access2000. Have a need for a form (I can have it refresh every 5,10 secs or so) that works like a report, no editing or data entry just requerys and requerys while it is open. The issue is that I need to time format in hours (and yes greater than 24), minutes, seconds. Found a formula that works great in a report but as I'm live monitoring the results and need to refresh every 5,10 secs or so, a report won't work. The formula in the report control is as follows =[SumOfTimeField]\3600 & Format(([SumOfTimeField] Mod 3600)/86400,"nn:ss") Same formula in the form control gives me an #ERROR# result. Changed the formula to =Sum([SumOfTimeField]\3600) & Format((Sum([SumOfTimeField] Mod 3600)/86400),"nn:ss") And got the right format to showbut received the same results for all 4 of the records on the form(it added them all up and that result then went to the field for each of the records.) The field [TimeField] is a number field measuring seconds from the beginning of the day. My result set sums that field (with criteria that would give me 4 subsets of totals) with other calculations to determine length of time. For example if I'm measureing logon time for 30 employees need to have results in hours:minutes:seconds without any days. Need to see the unique results for each record on the form. The underlying query used for the form is showing the correct data and if I select the data without formating I get the results just fine. Just need to format the results to the hours:minutes:seconds. HHHEEEEELLLLLLLPPPPPPP ( I believe in primal scream therapy ) :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
convert time imported as text to time format for calculations | batfish | Worksheet Functions | 3 | October 27th, 2005 11:24 PM |
How to format cells in Excel for time in format mm:ss.00 | Very Timely | Worksheet Functions | 0 | March 30th, 2005 07:35 AM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |
Format Axis - Time | Kevin Stecyk | Charts and Charting | 2 | May 26th, 2004 04:43 PM |
General format to Time format | Joe | Worksheet Functions | 2 | April 1st, 2004 04:18 PM |