Tag Archives: conversion

Time In Fractional Day As Used In Astronomy (e.g., MPC)– Excel Spreadsheet For Conversion (Both Ways).

by Anura Guruge

Click to ENLARGE.

What my Excel spreadsheet looks like. It is converting ‘.67810’ into a time format we can understand.

Time that comets are discovered are specified in this ‘fractional day’ format.

So, for example, time when C/2020 F3 (NEOWISE) was discovered per the ‘Minor Planet Center’ (MPC).

The .67810 used above is FROM this example.

Click to ENLARGE.

The Excel FORMULAS used in the Spreadsheet.

So, now you can quickly & easily create your own Spreadsheet.

Click to ENLARGE.

I had trouble deciphering this time format. I had to seek help from a professional astronomer — Jeff Mangum. [Thank YOU, Jeff.]

I then dashed off a quick Excel for MY use. Then I decided I should create a version that I can SHARE.

Yes, of course, I could make it a download — but many would be leary of downloading it. So, intead, I am sharing the simple Excel formulas you will need to create your own. Yes, it can be made simpler. SMILE. I just wanted to show YOU the steps so you could see where I was going. SMILE. Plus, I am, at 67, not the hotshot programmer I was when I was in my 20s. SMILE.

Related posts:
Check Category ‘Astronomy.

by Anura Guruge


Fujifilm X-E2s Takes Some Remarkable Shots Straight Out Of The Box.

by Anura Guruge

Click to ENLARGE.

Attribution may be sought.

Taken in Boston, Sunday, May 22, 2016. 

Anura Guruge Fuji X-E2s

Reduced 1024 x 683 image. Use link below to see it in its full-size, 4896 x 3264 glory.

Click here to see it in FULL SIZE.

JPEG. Untouched — not even in-camera RAW conversion. Shot as a JPEG. No post-processing. Manual focus. SMILE.

by Anura Guruge