Converting hrs:min to min

[carmen]

I have a table with two fields hrs and min. How can I combine the two fields
into just min then put the results into another field named TotalTime?

Thanks
Carmen

 

[fredg]

I have a table with two fields hrs and min. How can I combine the two fields
into just min then put the results into another field named TotalTime?

Thanks
Carmen

You can determine the total amount of time by using the dateadd
function. Since this is a query newsgroup you have posted in, add a
new column to the query grid:

TotalTimeateAdd("n",[Field1],[Field2])

Do you want to store it in a table?
Why would you want to?
As long as you already have stored in your table the 2 time fields
[Field1] and [Field2], whenever you need the total time simply repeat
the above calculation, in a query or if on a form or in a report using
=DateAdd("n",[Field1],[Field2]) as the control source expression in an
unbound countrol.

 

[John Spencer (MVP)]

Use a calculated field in the query.

Field: TotalTime: [Hrs]*60 + [Min]