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.
|