Conversion date

[hair]

Howdy

Now is that : I have a query that looks like this :

SELECT (Sum(Planning.TotalHeures))
FROM Planning
WHERE (((Planning.[Nom Agent])=Forms!Plan.Texte5));

The thing is I have the time in hours in the field TotalHeures and the result of the query is something like 1.653333 for example. So I need to do a conversion. I tried to say sum*24 but it's wrong. I should format it somewhere like hh:mm I suppose but as I being a beginner I really have no idea. Thanks for help.

 

[hair]

actualy the subject should be conversion hours, sorry for inconvenience

 

[nightwalker]

hours conversion

i would do it by VBA:
on a button click or any other event's sub procedure i would use MOD and / to get the quotient and remainder of the hours ...

i dont perfectly understand what you are actuall lookin for but i just thought of this silly way :
convert the field in the table design to take only two places by making it of type "Fixed"
dim mm, hh,result as string
([hours] mod cint([hours]))*100=mm
cint([hours])=hh
result=hh & ":" & mm

If that is not what you are looking for you can use Mod and Div='/' operators to solve your problem ...

if it still doesnt help then lemme know ...
Thanks
walker