convert this time 54309495 = 17:15

[betterdays1]

I need to know how to convert this Julian Time ( I think ) to something I can actually use. My example is Start Time: 54309495, this actually equals 17:15. Any formula help would be GREATLY appreciated.

thanks

 

[synapsevampire]

There are a few whitepapers on Julian dates, but it's key to know that it is in fact a Julian date.

There are Functions (UFL) you can add to CR to work with Julian dates:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_ufls.pdf

-k

 

[betterdays1]

I'm not positive that it is a Julian Date/Time field. I do know that I downloaded all of those UFL's and none of them give me anything back that looks like a real date or time. This may be seconds since something? I'm not even sure about that. I'm using call center software called TCS (Tele Center Systems). Anyone else???

 

[Madawc]

Give us a few more examples and someone might be able to figure out the underlying logic (if any). What value does it have at 16:15, say? And is it the same every day, or else what is the same time on two successive days?

Madawc Williams
East Anglia
Great Britain

 

[betterdays1]

This particular record is for 4/3/2003.
The [Start Moment] = 54309495 or 17:15
The [Stop Moment] = 54310005 or 1:45

Example #2 is for 4/3/2003
The [Start Moment] = 54309180 or 12:00
The [Stop Moment] = 54309675 or 20:15

thank you for any help you can lend.

 

[SmpTraining]

I think this is the number of minutes since 1900.

If you take any two away it gives the number of minutes difference between the times.

54,309,180 minutes =
905,153 Hrs =
37,714.708 Days = approx 103 years.

I know I have too much time on my hands but I could't work this right back to the extact day/time it started from (sorry!)


Steve Phillips, Crystal Consultant

 

[Reebo99]

If 4/3/2003 = 4th March 2003
29th November 1899, 19:00

If 4/3/2003 = 3rd April 2003
29th December 1899, 19:00


Reebo
Scotland (Sunny with a Smile)

 

[betterdays1]

has anyone used a datediff on something like this before?

 

[Madawc]

Assuming that Crystal cannot be persuaded to recognise the number of minutes as a date, you need something like:

DateAdd ("n", {julian.field}, #29th November 1899, 19:00#)

This will add the number of minutes to the starting date and should give you the actual date in familiar format. (Since I use a database that doesn't record time, I may not have the format exactly right.)

Madawc Williams
East Anglia
Great Britain