Adding up hours and minutes

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I am trying to add up a column of hours and minutes. The
data has been entered as follows:

4.55
6.10

The total should calculate to 11 hours and 5 minutes.

Is there a way that excel can recognise hours and minutes
and total them accordingly without me having to convert
all the numbers to minutes and then total them up etc.

Thanks
Lynn
 
Hi Lynn

If you use a colon rather than a point between the numbers, Excel will
interpret this as Time.
Then you can sum the range of dat to get the total time.
Format the cell containing your summation as Custom Format [hh]:mm to allow
the result to sum past 24 hours.

To convert the data that has already been entered, mark the block of data
and do a Search and Replace for "." to ":" (do not include the quotes)
 
Hi Lynn
why do you use the point as separator?. If you change this to a colon
Excel will recognize your values as time automatically. e.g.
4:55
6:10

Now you can simply add the cells. You may format the target cell with
the custom format '[h]:mm' to prevent the rollover after 24 hours

HTH
Frank
 
Hi Frank

Thanks for the help its working fine.

Lynn
-----Original Message-----
Hi Lynn
why do you use the point as separator?. If you change this to a colon
Excel will recognize your values as time automatically. e.g.
4:55
6:10

Now you can simply add the cells. You may format the target cell with
the custom format '[h]:mm' to prevent the rollover after 24 hours

HTH
Frank

I am trying to add up a column of hours and minutes. The
data has been entered as follows:

4.55
6.10

The total should calculate to 11 hours and 5 minutes.

Is there a way that excel can recognise hours and minutes
and total them accordingly without me having to convert
all the numbers to minutes and then total them up etc.

Thanks
Lynn
Click to expand...


.
Click to expand...
 
Roger,

Thanks for the help - works great.

Lynn
-----Original Message-----
Hi Lynn

If you use a colon rather than a point between the numbers, Excel will
interpret this as Time.
Then you can sum the range of dat to get the total time.
Format the cell containing your summation as Custom Format [hh]:mm to allow
the result to sum past 24 hours.

To convert the data that has already been entered, mark the block of data
and do a Search and Replace for "." to ":" (do not include the quotes)
--
Regards
Roger Govier
I am trying to add up a column of hours and minutes. The
data has been entered as follows:

4.55
6.10

The total should calculate to 11 hours and 5 minutes.

Is there a way that excel can recognise hours and minutes
and total them accordingly without me having to convert
all the numbers to minutes and then total them up etc.

Thanks
Lynn
Click to expand...


.
Click to expand...
 
Thanks for the help. Works well


Lynn
-----Original Message-----
Hi

Enter time as
4:55
6:10

Now you can use SUM function or autosum feature



--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets





.
Click to expand...
 
Back
Top