Home » Questions » Computers [ Ask a new question ]

How to get time difference as minutes in Excel?

How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of the times in minutes.

Asked by: Guest | Views: 49
Total answers/comments: 2
Guest [Entry]

"Just set the cell to be shown in numerical format and it will show a decimal number.

The integer part corresponds to the date value (i.e. the day) and the decimal part to the time of the day.

If you multiply the numerical value of 1:45 (which is 0,07) by 24x60 (the number of hours in a day and the number of minutes in an hour) you will obtain the value in minutes of your cell (105)."
Guest [Entry]

"I think this will work:

A1 6:23
B1 8:23
C1 =(B1-A1)*24*60

Just make sure you format C1 as ""General"""