hour

[srinivasa1]

Hi can any suggest me how i can find hours from below  details

25:06:32 AM

81:00:18 AM

128:06:51 AM

152:59:36 AM

my result would look like

25

81

128

152

Pls  guide why my hour function is not working

thanks in adavance.

[MayilVahanan]

HI

Try like this:

=SubField('25:06:32',':')

hope it helps

[CELAMBARASAN]

Hi,

You can use hour function but only after formatting your data to the time format using Time#().

Here it still won't work because this is not in correct format 24 hr or 12 hr.

Its total time for more than 1 day. You can use

interval(interval#(Trim(Replace(Field,'AM','')),'hh:mm:ss'),'hh')

or simply go by mayil suggestion as

SubField(FieldName,':',1)

[srinivasa1]

Hi

Thanks for reply.i need only 25 so i wll consider this 25 hrs.

Thanks

[srinivasa1]

Thanks. Sorry  i made mistake now i got it correct

thanks to all