time

[Chink!]

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!

 

[Guest]

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!]

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!

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

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!