Converting numbers into time format

  • i was doing a report using crystal report xi wherein i am computing for the working time rendered by each technicians. i have a table named OSCL. into this table, I have a field name u_techInTime and u_techOutTime wherein the value is in number format. I wanted to display in my reports the working time using this formula:

    {OSCL.U_TechOutTime}-{OSCL.U_TechInTime} but the pro

  • Your question wasn't posted completely.

    also you'll need to figure out the "fomat" of your integer time column(s).

    - are they expressed in seconds ?

    - are they just numerical representations of hhmmss ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • second....I think....there are no 70 seconds on my watch

  • liviu.rabuga (4/1/2009)


    second....I think....there are no 70 seconds on my watch

    I can introduce you to my project manager, he can explain that. He sometimes also thinks that days have 30 hours. 😀

  • :-):-):-)

    my project manager think that too....

    are we working in the same company...?!!! :-D:-D:-D

    man...i must change that watch

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply