hour to minute

[Marco]

I have a field with time (hour, minute, seconds), how can i trasform to
minute (and decimal)?
es 03.22.46 202.766

thx

 

[Barry Gilbert]

CDbl(MyTimeValue) * 1440

 

[Guest]

Left("03.22.46",2) * 60 + Mid("03.22.46",4,2) + Right("03.22.46",2)/60

 

[Jeff Boyce]

Marco

Is the data type of that field a "text", or a "date/time"?

What is stored in a field and how it is displayed don't necessarily match...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marco]

"Jeff Boyce" wrote

Is the data type of that field a "text", or a "date/time"?
"date/time"?


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marco]

"Jeff Boyce" wrote

date/time


Regards

 

[Jeff Boyce]

Marco

If the underlying data type is "Date/Time", then you need to be aware that
there is both a date portion and a time portion. If you have only been
storing "time" (as in "duration"), this is not what the data type was
designed for.

You can use various time formats to change how the value is displayed. This
doesn't change the underlying data, just the appearance.

Regards

Jeff Boyce
Microsoft Office/Access MVP