Looking for trustworthy answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Explore thousands of questions and answers from knowledgeable experts in various fields on our Q&A platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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.