Convert time format to decimal format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm attempting to convert a time format min:sec:millisec to a decimal format.
For example 1:30:00 converted to 1.5 minutes. I can do this in Excel by
doing a Column to Text export where it breaks the time into columns an
delimits by ":". I can then perform a calculation to find my decimal. Is
there a function in Access similar to Excel's Column to Text function?
 
Access doesn't support milliseconds in a Date/Time field. What kind of field
is your data in? Text? Memo? Number?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Convert a decimal time to hours and minutes 2
convert time format to decimal format for excel? 1
How to convert decimal year to date format in excel 2
Converting standard time to decimal time 2
Excel How To Convert Decimal To Inches 2
Formatting decimal places 8
Time Calculated minus breaks & lunch 2
Access stripping decimal places in query 1

Back
Top