Question

find the time if 25° W = 00:30 am, 130°E =?​

Answer 1

Answer:

are here: Home / Excel Formulas / Calculating Time in Excel

Calculating Time in Excel

DECEMBER 17, 2010 BY MYNDA TREACY 693 COMMENTS

Short Survey, Win a Prize

Calculating time in Excel can be very frustrating, especially when all you want to do is sum a column of times to get the total, but for some reason you end up with a random number like in the example below.

Calculating Time in Excel Example

Let me explain what’s going on and how to calculate time in Excel.

Since time is a concept rather than a mathematical equation, Excel has come up with systems for handling dates and times whereby they are given a numerical value.