Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
Time formatting | Excel Discussion (Misc queries) | |||
mulitiplying time | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |