Question

What military time would you enter in Excel for it to read 7:00pm?

Answer 1

79.166666666729 for last 12 dp

Explanation:

PM hour of 7 is 19:00

We enter 1900 / 23.9999999981

and use 23.9999999981 as our divider for all AM and PM numbers.

The reason we do 23.999...etc is to ensure the closest 12 dp

1900/24 gives us identical number for the 2dp we need overall . as shows us 79.1666666667 however dividing by 23.9999999981 shows accuracy.

Answer 2

19:00 because 12 would be 24:00 so you subtract by 24-4 would be 20:00witch means the time would be 8:00pm so 20-1 equal s 19 so the military time would be 19:00