Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate the hours and minutes in excel
I am trying to calculate the total hours and minutes by weelky in excel. The
problem is if the hours are 10.5 ( 10hour and 30 minutes). IF i calculate the 10.5 by $14 and hour it gives me 147. but if i multiply 10.30 by 14, it gives me 144.2. I am confused i don;t know what i should do. Please help me. Thank u in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate the hours and minutes in excel
You are confusing minutes with decimals. 30 minutes is 1/2 or 0.5 hours. 15
minutes is 1/4 or 0.25 hours, etc. "Mital" wrote: I am trying to calculate the total hours and minutes by weelky in excel. The problem is if the hours are 10.5 ( 10hour and 30 minutes). IF i calculate the 10.5 by $14 and hour it gives me 147. but if i multiply 10.30 by 14, it gives me 144.2. I am confused i don;t know what i should do. Please help me. Thank u in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate the hours and minutes in excel
Hmmm, I already replied but I don't see my reply to you. Since this is my
first time using this forum, I'll reply again. If the delay is just a normal time lag here, then we'll finally see two posts from me with duplicate info. You're confusing minutes with decimals. 30 minutes is 1/2 or 0.5 hours. 15 minutes is 1/4 or 0.25 hours, etc. "Mital" wrote: I am trying to calculate the total hours and minutes by weelky in excel. The problem is if the hours are 10.5 ( 10hour and 30 minutes). IF i calculate the 10.5 by $14 and hour it gives me 147. but if i multiply 10.30 by 14, it gives me 144.2. I am confused i don;t know what i should do. Please help me. Thank u in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate the hours and minutes in excel
Check out the following URL for some useful date & time calculations for
Excel users. I think you'll find it quite useful. http://www.cpearson.com/excel/datearith.htm -- Kevin Backmann "davidderolph" wrote: Hmmm, I already replied but I don't see my reply to you. Since this is my first time using this forum, I'll reply again. If the delay is just a normal time lag here, then we'll finally see two posts from me with duplicate info. You're confusing minutes with decimals. 30 minutes is 1/2 or 0.5 hours. 15 minutes is 1/4 or 0.25 hours, etc. "Mital" wrote: I am trying to calculate the total hours and minutes by weelky in excel. The problem is if the hours are 10.5 ( 10hour and 30 minutes). IF i calculate the 10.5 by $14 and hour it gives me 147. but if i multiply 10.30 by 14, it gives me 144.2. I am confused i don;t know what i should do. Please help me. Thank u in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hours & minutes ADDITION IN EXCEL | New Users to Excel | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
How do I calculate hours in Excel | New Users to Excel | |||
how to add hours and minutes in excel | New Users to Excel | |||
calculate average hours and minutes | Excel Worksheet Functions |