time:How can I enter a figure for contracted hours which is greater than 24 hours?

I am trying to make a spreadsheet to calculate hours worked etc

The user inputs start and finish times during the week and these are
totalled up.

Then I want to subtract contracted hours from the total and see any extra
hours worked

for example my contracted hours are 27 and I enter that in a cell
I enter in my start and finish times and these are totalled up.

Total hours work - contracted hours = extra
How can I enter a figure for contracted hours which is greater than 24
hours?
What cell format should I use?

many thanks
CH!

To see excel formatted hiours over 24 use [hh]:mm as format, to subtract 27
hours entered as an integer use

=total_hour-(27/24)

note that excel windows default time cannot show negative hours then you
need to convert to decimal hours first

=(total_hour*24)-27

format as general


Regards,

Peo Sjoblom

"Chink!" wrote:

> I am trying to make a spreadsheet to calculate hours worked etc
>
> The user inputs start and finish times during the week and these are
> totalled up.
>
> Then I want to subtract contracted hours from the total and see any extra
> hours worked
>
> for example my contracted hours are 27 and I enter that in a cell
> I enter in my start and finish times and these are totalled up.
>
> Total hours work - contracted hours = extra
> How can I enter a figure for contracted hours which is greater than 24
> hours?
> What cell format should I use?
>
> many thanks
> CH!
>
>
>

Not sure I understand
I tried using the formula you suggested and it wouldnt allow subtraction by
hh:mm figures
I want the user to enter their normal hours eg 19, 27, 35 whatever
and subtract this from a total amount of time such as 39:00 to give the
figure of extra hours worked

CH!

"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> To see excel formatted hiours over 24 use [hh]:mm as format, to subtract
27
> hours entered as an integer use
>
> =total_hour-(27/24)
>
> note that excel windows default time cannot show negative hours then you
> need to convert to decimal hours first
>
> =(total_hour*24)-27
>
> format as general
>
>
> Regards,
>
> Peo Sjoblom
>
> "Chink!" wrote:
>
> > I am trying to make a spreadsheet to calculate hours worked etc
> >
> > The user inputs start and finish times during the week and these are
> > totalled up.
> >
> > Then I want to subtract contracted hours from the total and see any
extra
> > hours worked
> >
> > for example my contracted hours are 27 and I enter that in a cell
> > I enter in my start and finish times and these are totalled up.
> >
> > Total hours work - contracted hours = extra
> > How can I enter a figure for contracted hours which is greater than 24
> > hours?
> > What cell format should I use?
> >
> > many thanks
> > CH!
> >
> >
> >