hh:mm:ss to decimal number?

[skearton]

Can anyone help me do this?

hh:mm:ss to decimal number

I've seen the function to do just hh:mm to a decimal number, but I'm not sure how to be able to handle the seconds part of it.

[comment]

What exactly is "hh:mm:ss" - is it text, time or...? And "decimal number" - a number of what?

[skearton]

What exactly is "hh:mm:ss" - is it text, time or...? And "decimal number" - a number of what?

It is time format and I think I have it figured out.

The convert time field to a decimal number formula would be this (just need to test it still):

Hour (time field) + (((Minute (time field) x 100) / 60) + (Second (time field) x 100) / 3600) / 100

Had to tweak it - this is the correct calculation:

Round

(Hour (xTime) +

(((( Minute (xTime) * 100) / 60) +

(Seconds (xTime) * 100) / 3600)

/ 100); 6)

[comment]

(Hour (xTime) +

(((( Minute (xTime) * 100) / 60) +

(Seconds (xTime) * 100) / 3600)

/ 100)

How about just =

xTime / 3600

[jbante]

You can also simply do this: GetAsNumber ( xTime ), or with a text string representing the time: GetAsNumber ( GetAsTime ( xTimeString ) )

[comment]

That will give you the number of seconds - not hours as the OP wants.