Converting Times

[Anonymous]

Hello,

I have stored times in my database with the minutes in 100 base, so that it works well with the maths counts, but I'd like to show the results in the time format.

Example

4,75+4,75=9.5 hours ---> Graphically 9:30 hours.

Can anyone help me?

Thanks.

[#2]

HH:MM

[Anonymous]

Sorry, Can you explain better to me? (I'm a rookie).

In the table I have the Sum expression for the hours in format like 9,5 and I'd like to display the results in 9:30.

Which choise I have to make in the Numer Tag?

Thank you.

[#4]

Hi,

First you will need to convert your number into a format that can be converted into time (like 9:30 would be = 0.395833) then do a code like

=Time(.395833,'HH:mm')

make sure the m is small letter or else it would be in Month Format.

Regards,

[#5 · Accepted solution]

Hi

I found a better way of computing it..

=Time((your number)/24,'hh:mm')

lets say your number = 9.5 then it will result to 9:30, if your number is 10 then it will result to 10:00

Regards,

[Anonymous]

Sorry, but it doesn't work properly:

Time (9.5/24,'hh:mm')=9:30

but

Time(9.25/24'hh:mm') doesn't show 9:15 but 9:12 (!)

Thanks.

[Anonymous]

Solved!

I put in the expression 9.25/24 and in the tag Number the format Hour hh:mm

Thank you very much for the suggestions.