Convert Time hh:mm:ss to number

[#1]

Hello,

I received a 'timestamp' like 01:45:00 and these are the hours a employee worked in the building.

Is there a formula whih can convert this to 1,75 'hours'....

Friso 

[Chanty4u]

may be u can try

=    Interval#('01:45:00', 'HH:MM:SS') * 24

[Chanty4u]

orelse

Data:

Load *,

Timestamp(Timestamp#( TIMESTAMP,'DD/MM/YYYY hh:mm:ss:fff'), 'hh:mm:ss')  as Time,

Timestamp(Timestamp#( TIMESTAMP,'DD/MM/YYYY hh:mm:ss:fff'), 'hh')  as Hour;

load * Inline

[

TIMESTAMP

26/10/2014 01:06:44:340

]

[mightyqlikers]

HI try this.

hour('01:45:00')+Minute('01:45:00')/60

$@M.

[sunny_talwar]

This seems to work as well:

=Time#('01:45:00', 'hh:mm:ss') * 24

or this in the script

Time#(TimeField, 'hh:mm:ss') * 24 as WorkingHours