Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can i add times in Excel?
So i have been trying to make a worksheet to calculate my pay with deductions
and everything. But the thing is that my punch machine works in decimals. So i changed that with a formula =TEXT(A1/24; "h:mm") which works great. But now i want to add times, but it doesn't seem to work. I have tried =SUM(A1:A6)*24 (as suggested in the excel help) but i found out (well i think) that SUM does not count TEXT. When i try the same formula with hours i have entered myself, instead of results entered mathematically, it works. I do not know what do to. |
#2
|
|||
|
|||
Instead of using
=text(a1/24;"h:mm") Just use =a1/24 but format that cell as time. Then add those helper cells to see what you get. If you want the results as hours, try a format like: [h]:mm "ExcelMe " wrote: So i have been trying to make a worksheet to calculate my pay with deductions and everything. But the thing is that my punch machine works in decimals. So i changed that with a formula =TEXT(A1/24; "h:mm") which works great. But now i want to add times, but it doesn't seem to work. I have tried =SUM(A1:A6)*24 (as suggested in the excel help) but i found out (well i think) that SUM does not count TEXT. When i try the same formula with hours i have entered myself, instead of results entered mathematically, it works. I do not know what do to. -- Dave Peterson |
#3
|
|||
|
|||
Avoid TEXT. Use sinply
=A1/24 and format the cell as time in the Format Cells menu. HTH. Best wishes Harald <Excel skrev i melding ... So i have been trying to make a worksheet to calculate my pay with deductions and everything. But the thing is that my punch machine works in decimals. So i changed that with a formula =TEXT(A1/24; "h:mm") which works great. But now i want to add times, but it doesn't seem to work. I have tried =SUM(A1:A6)*24 (as suggested in the excel help) but i found out (well i think) that SUM does not count TEXT. When i try the same formula with hours i have entered myself, instead of results entered mathematically, it works. I do not know what do to. |
#4
|
|||
|
|||
Wow thank you so much it was so simple!
now i only have to multiply this total of hours with my wage. how is that possible? do i have to turn back my total of hours in decimals? |
#5
|
|||
|
|||
=A1*the_rate
or if you have a summed time in say H1, then =H1*24*the_rate -- HTH RP (remove nothere from the email address if mailing direct) "ExcelMe" wrote in message ... Wow thank you so much it was so simple! now i only have to multiply this total of hours with my wage. how is that possible? do i have to turn back my total of hours in decimals? |
#6
|
|||
|
|||
It works!! thank you so much!!
"Bob Phillips" wrote: =A1*the_rate or if you have a summed time in say H1, then =H1*24*the_rate -- HTH RP (remove nothere from the email address if mailing direct) "ExcelMe" wrote in message ... Wow thank you so much it was so simple! now i only have to multiply this total of hours with my wage. how is that possible? do i have to turn back my total of hours in decimals? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |