Re: formula changing

Brian -

Your formula turns the result of the subtraction into text. I couldn't
make it sum the results. Use a regular subtraction formula in the cell:

=B1-A1

then apply this custom number format to the cells that contain these times:

[h]:mm

(Format menu - Cells - Numbers tab, select Custom on the left, and enter
[h]:mm in the box). The brackets around the h tell Excel to use times
over 24 hours.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

brian hedley wrote:
> Hi
> I am having problems with a formula
> I am trying to create a working time sheet that will
> display all hours worked in a week
> I have for example created a sheet that has the following
> data
> =TEXT(B1-A1,"H:MM")
>
> A1 CONTAINS 14:00
> B1 CONTAINS 15:00
> B3 =TEXT(B1-A1,"H:MM")
> RESULT IN B3 IS 1:00
> THIS IS FINE UNTIL I ENTER A SUM TO CALCULATE ALL OTHER
> TIMES AND REACH BEYOND 23:59 AS IT RETURNS TO 00:01 ETC
>
> I WANT TO EXTEND THE TIME FORMAT TO ALLOW ME TO
> SHOW ALL HOURS WORKED IN A WEEK AND TOTAL THEM ON A CELL
> AS HOURS AND MINUTES
> ANY HELP WOULD BE APPRECIATED
> REGARDS