hour calculator
Thread Starter
Join Date: Oct 2005
Location: !
Posts: 21
Likes: 0
Received 0 Likes
on
0 Posts
hour calculator
Hi guys,
looking for a quick and easy way to add hours.
Tried with excel several times.. it works but once in a while the cell formatting gets mixed up and it's a complete mess!
I need something quick where you can paste your hours in a HH:MM format and get the total in total hours and decimals eg: 10:30 hours = 10.5 hrs
Anything that you use already maybe?
looking for a quick and easy way to add hours.
Tried with excel several times.. it works but once in a while the cell formatting gets mixed up and it's a complete mess!
I need something quick where you can paste your hours in a HH:MM format and get the total in total hours and decimals eg: 10:30 hours = 10.5 hrs
Anything that you use already maybe?
More bang for your buck
Join Date: Nov 2005
Location: land of the clanger
Age: 82
Posts: 3,512
Likes: 0
Received 0 Likes
on
0 Posts
Join Date: Jun 2006
Location: High up
Posts: 3
Likes: 0
Received 0 Likes
on
0 Posts
It's a bit wierd but, let's say you enter 10:55 in cell A1.
In cell B1, enter the formula for conversion: =A1*24
Excel's brainless 'Intellisense' will try to display it in HH:MM format which makes no sense: You need to change the number format to Number, 2 decimal places, and you will get 10.92
This will work with huge amounts of hours beyond 24.
Good luck...
In cell B1, enter the formula for conversion: =A1*24
Excel's brainless 'Intellisense' will try to display it in HH:MM format which makes no sense: You need to change the number format to Number, 2 decimal places, and you will get 10.92
This will work with huge amounts of hours beyond 24.
Good luck...
Join Date: Sep 1999
Location: ME
Posts: 5,502
Likes: 0
Received 0 Likes
on
0 Posts
Try this
=(A4-INT(A4))*24
Make sure column A is HH:MM then put the formula in column B, (This can be hidden later)
You can add the figures in column B normally as they are decimals, lets say..
=sum(B1:B10) this is in B11. If column A11 = B11, you will get a HH:MM total.
I'm sure that there are other ways, but this works.
Mutt
=(A4-INT(A4))*24
Make sure column A is HH:MM then put the formula in column B, (This can be hidden later)
You can add the figures in column B normally as they are decimals, lets say..
=sum(B1:B10) this is in B11. If column A11 = B11, you will get a HH:MM total.
I'm sure that there are other ways, but this works.
Mutt
Join Date: Apr 2005
Location: Earth
Posts: 366
Likes: 0
Received 0 Likes
on
0 Posts
I like that a lot, Capn Bloggs. A lot less keyboard action compared to inputting hh:mm
But I think that for asddsa to get his decimal minutes (.1, .5, .7 for example), he will have to use the ROUND function on the Totals cell (in your example, C8) of column C. =ROUND(C8/60,1)
But I think that for asddsa to get his decimal minutes (.1, .5, .7 for example), he will have to use the ROUND function on the Totals cell (in your example, C8) of column C. =ROUND(C8/60,1)
ROUND would do it.
Thread Starter
Join Date: Oct 2005
Location: !
Posts: 21
Likes: 0
Received 0 Likes
on
0 Posts
Hello Mr. Bloggs!
I really like your xls but I cannot select the cells for the totals to move them down and add more rows!
I need about 15 rows to add the flt times..
Did you lock it in any way or am I just dumb?
I really like your xls but I cannot select the cells for the totals to move them down and add more rows!
I need about 15 rows to add the flt times..
Did you lock it in any way or am I just dumb?
Using dates & times in Excel is a doddle, if you're willing to take a little time to learn it. Sometimes the automatic formatting works, sometimes not - so you may as well get used to doing it manually, then you always know where you are. Handy shortcut key: Ctrl+1 brings up the cell formatting box.
It also helps to remember that in Excel's internal representation, a day = 1, so an hour = 1/24 days, and so on. That has to be correct before the formatting will look right - if it all seems bizarra, check it by going back to "general" format.
It also helps to remember that in Excel's internal representation, a day = 1, so an hour = 1/24 days, and so on. That has to be correct before the formatting will look right - if it all seems bizarra, check it by going back to "general" format.
