Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting hours into minutes
I have 2 colums, one in hours and one in minutes, i have converted the
minutes into hours and minutes how do i add the hours with the converted hours and minutes? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting hours into minutes
Hi,
=A1+B1 would add the 2 times Format the cell [hh]:mm Mike "Alison" wrote: I have 2 colums, one in hours and one in minutes, i have converted the minutes into hours and minutes how do i add the hours with the converted hours and minutes? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting hours into minutes
=A1/24+C1
and format as time -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alison" wrote in message ... I have 2 colums, one in hours and one in minutes, i have converted the minutes into hours and minutes how do i add the hours with the converted hours and minutes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |