Trying to convert a number to Time 4

[kcsilentbob]

I use AWD which pulls time in to Crystal as HH:MM:SS. So data displayed on crystal is listed as 5,107.00 which should be 00:51:07.

Here is my problem:

I need that number to be read as time. What is happening is that I am trying to average a number as time and of course it is not reading properly.

Please help

 

[lbass]

Please see my post from 12/14 14:50 for direction on how to convert to hh:mm:ss.

-LB

 

[kcsilentbob]

Flat out awesome!

Guys thanks soooo much for your help on this. Mr. Moderator you can archive this if you want. All of my questions have been answered.

 

[DataDog]

I've never seen anything go away (archive) here.

A nice thing to do would to be to give a star for those that helped you out. Just click on "Thank <handle> for this valuable post!" in their record.

DataDog
'Failure Is Not An Option'