Converting HH:MM to decimal

[katrinanyc926]

What is the formula for a query to convert time that shows up in HH:MM format to make it show up in decimal format??? Please help!!!!

[pbaldy]

Does TimeValue() do what you want?

[katrinanyc926]

I'm not sure, haven't tried that yet. Let me try now.

[katrinanyc926]

OK, that doesn't work. I want the time to appear as a decimal number not the HH:MM format. The report I am doing is for showing how much time someone has worked on something.

[ajetrumpet]

OK, that doesn't work. I want the time to appear as a decimal number not the HH:MM format. The report I am doing is for showing how much time someone has worked on something.

if you want a mathematics approach, just use operations. what decimals do you want? what's the basis for the data? DAYS? HOURS? MINUTES?

for example, a field that is DATE/TIME type as shows a value of 12:38 (12 hrs and 38 min), and your basis is HOURS, do this to the field in your sql:

select clng(left(FIELD, 2) & round((right(FIELD, 2) / 60), 2)) 

[weekend00]

I think you have the hours in a number field. So simply change the format of the textbox to General in the report .