Converting Decimal Time to Regular Time

[elliotmf]

Hello,


I need a format function for a query that will Convert: Decimal Time to Regular Time.

For Example my Database stores 8 Hours and 15 Min as: 8.25000008940697

And now I need a function to bring it back to: 8.15

Any help is greatly appreciated.

[missinglinq]

Hours = int(OriginalTime)    
 
Minutes = int((OriginalTime-int(OriginalTime))*60)
 
NewTime = Hours & "." & Minutes

or in a calculated field in the Query Grid

NewTime: int(OriginalTime) & "." & int((OriginalTime-int(OriginalTime))*60)

Welcome to TheScripts!

Linq ;0)>

[elliotmf]

Wow, pretty good.

Now, I need to sum this feild and I'm having issues with that.

When I keep it the feild a NUMBER format is cuts off the minuites and if I keep the feild a TEXT feild I can't do a SUM Total.

Thanks Again.

[elliotmf]

I think I found my issue, But I can't see to solve it:

My Database records it as :6.08333333954215

Which is: 6 Hours and 5 Minuites

When I run the function you gave me it returns:

6.5

When we really need it to return 6.05


Thanks!!

[ADezii]

I think I found my issue, But I can't see to solve it:

My Database records it as :6.08333333954215

Which is: 6 Hours and 5 Minuites

When I run the function you gave me it returns:

6.5

When we really need it to return 6.05


Thanks!!

Following Linq's logic:

? Format(int(6.08333333954215) & "." & int((6.08333333954215-int(6.08333333954215))*60), "hh:mm" returns 06:05

[missinglinq]

Thanks for the assist, ADezii! I was in a hurry and only tested against the data provided! I apologize!

Linq ;0)>

[ADezii]

Thanks for the assist, ADezii! I was in a hurry and only tested against the data provided! I apologize!

Linq ;0)>

Anytime Linq, just didn't want you to think that I was stepping on your toes (LOL).

[elliotmf]

Thanks, I guess the issue I'm having is:

I can't seem seem to Total the results, I tried a query and I also tried doing a Sum in the report. I get an error message in ACCESS that the query is too Complex.

Here is what I'm doing:

Value of Feild: 8.15000009536743
When I run the Query I get 8:09 (which is good)

But when I try to run a query to TOTAL the results--I get the Error Message.

I tried dumping the info to a table, but if I set it to TEXT I can't TOTAL it.. and if I set it to number I loose the values

Please Help.
Thanks

[missinglinq]

I think what you need to do is to run you total against the original field (your "decimal" times) and then plug the results into the formula above to get your total in hours and minutes.

Linq ;0)>

[elliotmf]

Thanks!! It worked. Thanks for ALL Your Help.

[missinglinq]

Glad we could help!

Linq ;0)>

[elliotmf]

Hello,

The report basicly workds for me, But I'm still having an issue properly formating decimal time to regular time in totals. I was thinking to email you guys the Database it's a small Access 2003 DB. Is anyone instrested in helping in this way?