adding numbers with are saved as text

[amna77]

Hi, In table I have field, its text field. in that field I am saving time
format: hh:mm:ss like hours minute and seconds. now I want to add the time. how would I do that? is there any example? please help me.
Thanks in advance.

 

[Royal Presence]

In design view, why can you not
designate the field as date/time?

Then
below frame, state something like now() or whatever time you want?

Not sure if I am understanding.

 

[SydneyGeek]

If the field type is Date/Time, go to the field in the table's Design view.
Select the field in the top section.
In the Properties section below, there is a line called Default Value.
In that line enter =Now()
Every new record now gets the current date and time. Is that what you needed?

Denis

 

[amna77]

no actually I am saving time in my table as hh:mm:ss
and now on the report i want to sum that time up for all records for one day.the thing is I am saving time as a text field. how would I sum that up.

Thanks

 

[Andrew Fergus]

Hi, why have you formatted this field as text? Is there a reason for this? If the format is text are you able to input characters (as opposed to numbers) into this field? For example, can you enter something like ab:cd:ef?
Andrew

 

[SydneyGeek]

OK -- not sure why you used text but there's a workaround.

Build a query with the StartText and EndText fields, plus whatever else you need -- names, etc.
In the first blank column in the query's Design view, paste this expression:
TimeUsed: CDate([endText])-CDate([startText])
Right-click in the field (still in Design view), select the Properties, and set the Format to hh:nn:ss

Adjust field names to suit.
That should do the job for you

Denis