difference between julian dates

[Jon Savage]

Hello there,
I would first off like to thank ya for the great info that you have available on your site and that I am always amazed at some of the solutions that you come with. Been a great help to me many a times.

I have been trying to figure out a way to get the total time difference (in hour and minutes) between two julian dates and times. For example, a program that I use at work uses a "julian" date of "4032 1630" to equal 1 feb 04 at 4:30 pm. So I'm needing to be able to find the total hours and minutes difference between say "4032 1630" and "4048 2214". I figure that this must be easy to do using the date and time as a serial number then format the difference as a hour and minute but I'm at lost how to do this . Any way that you can assist me on this would be greatly appreciated. Thanks again, Jon

 

[Jon Savage]

IT WORKED!! Thanks there PaddyD. This little problem has been buggin' me for many moons. Will definity make my life easier. Now just need to figure out a array or something to convert those minutes to decimals for another part of my work (IE 1-2 min=0, 3-8 min=.1, 9-14 min=.2, 15-20 min=.3, ect) Can't be to hard Thanks again PaddyD and everybody else too. Jon

 

[PaddyD]

Book2
	A	B	C	D
18	00:01	0.02
19	00:02	0.03
20	00:03	0.05
21	00:04	0.07
22	00:05	0.08
23	00:06	0.10
24	00:07	0.12
25	00:08	0.13
26	00:09	0.15
27	00:10	0.17
28	00:11	0.18
29	00:12	0.20
30	00:13	0.22
31	00:14	0.23
32	00:15	0.25
33	00:16	0.27
34	00:17	0.28
35	00:18	0.30
36	00:19	0.32
37	00:20	0.33
38	00:21	0.35
39	00:22	0.37
40	00:23	0.38
Sheet1