how to convert spreadsheet cells to units of time?

Posted on

QUESTION :

This is the goal:

   +------+---------------------+---------+---------------------+
   | A    |        B            | C       |        D            |
   +------+---------------------+---------+---------------------+
1  | Joe  | 2016/04/01 00:00:00 | 15      | 2016/04/01 00:15:00 |
   +------+---------------------+---------+---------------------+
2  | Rick | 2016/07/01 00:10:15 | -6      | 2016/07/01 00:04:15 |
   +------+---------------------+---------+---------------------+

D1 = B1+C1

How do I define a cell as ‘minutes’ or ‘hours’ but not a full ‘time’ or ‘date’ entry

ANSWER :

The formula would be

=B1 + C1/(24*60)

As Excel denotes time as a decimal based on 24 hours being 1.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *