# Time Conversion Question

#### KuraiChikara

##### Board Regular
Hello everyone,
I just had a question on what the technical name of changing time into decimals is called.

For example 1 hour 15 mins is 1.25, 1 hour 30 mins is 1.50, 1 hour 45 mins is 1.75. So on and so forth. 2 hours 32 mins is 2.53.

The formula in excel from two cells (one with Hours and one with Mins) is
=((A2*60)+B2)/60

However, I do not know the technical name of this time conversion. Is there a name for it?

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### FDibbins

##### Well-known Member
What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 23 Oct 2017) is actually 43031

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So, having said that, if TIME is entered correctly, 1 hr 15 minutes (1:15 AM) is actually 0.000868056

When working with time, it is almost always better to work with actual (real) time, rather than using whole numbers to "represent" time

Replies
9
Views
252
Replies
8
Views
114
Replies
1
Views
140
Replies
7
Views
303
Replies
11
Views
239

1,129,734
Messages
5,638,052
Members
417,001
Latest member
MSteel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back