# Input hours and minutes

#### markmac234

##### New Member
Hi
I am having difficulty inputting hours and minutes. I want to enter the time like 1.15 and not 75 mins. Any ideas? I have formatted the result column as h:mm but because of the decimal time problem, I can't find a way to enter the data.

Mac

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Not sure what your'e asking. are you using : and not . as in your post. Also if it is an adding problem use [h]:mm in the custom format.

Colin.

Thanks for the reply. I mean 1.15 and not 1:15. It refers to 1 hour 15 minutes and not 1:15 am/pm. Basically I have to input flight hours into a table and more often than not they are in hours and minutes and not just minutes. The next column in the table is a running total for each row, which refers to a different aircraft. I have got the table working fine, but only if I use minutes i.e. 75 or 90 instead of 1hr 15, 1 hr 30 etc...Some of the hours I have to input are large so it would take a while converting all the inputs into minutes first. Hope this clears it up...
Thanks

If you input 1.5 into A1, format B1 as time 13:53. Now make B1=A1/24. This works for me.

markmac234 said:
Thanks for the reply. I mean 1.15 and not 1:15. It refers to 1 hour 15 minutes and not 1:15 am/pm. Basically I have to input flight hours into a table and more often than not they are in hours and minutes and not just minutes. The next column in the table is a running total for each row, which refers to a different aircraft. I have got the table working fine, but only if I use minutes i.e. 75 or 90 instead of 1hr 15, 1 hr 30 etc...Some of the hours I have to input are large so it would take a while converting all the inputs into minutes first. Hope this clears it up...
Thanks

Excel does not recognize 1.15 as 1:15. You can convert a true time value (1:15) to a decimal number by multiplying by 24 or a decimal (1.15) by dividing by 24. Either way, you'll have to be consistent in the data entry. 1.15 converted to a true time value is 1hr 09mins. 1:15 converted to a decimal is 1.25

With 1.15 in A1, you could use
=INT(A1)/24+MOD(A1,1)/14.4

with an approriate time format to reflect 1:15

Have a look at my post:

Good luck

bullit,
find your post (link) from the search box-right click-copy then paste it in your new message box.

Colin.

Like this?:

http://www.mrexcel.com/board2/viewtopic.php?t=19553&highlight=[/url]

Yep!
Colin.

Replies
2
Views
434
Replies
18
Views
549
Replies
26
Views
892
Replies
5
Views
321
Replies
4
Views
454

1,219,936
Messages
6,151,066
Members
451,006
Latest member
dhinze84

### 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