At Westonci.ca, we provide reliable answers to your questions from a community of experts. Start exploring today! Discover comprehensive solutions to your questions from a wide network of experts on our user-friendly platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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

Sagot :

Answer:

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

Answer:

79.166666666729 for last 12 dp

Step-by-step 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.