tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Just sorting out next years time sheet and i have a few problems,
I know time can be entered into excel as a time like "12:30:00"
but this is both difficult and slow so i want to be able to enter a start time and and end time as you do numbers so 10.00 to 14.45 for example
so this is what i need
Start time is in "D10"
End Time is in "E10" work out the hours worked as a decimal. so 3 and half hours is "3.50" etc
the another formula id possible to tell me how much time was before 7am?
so if you worked 5.30 till 17.00 thats 11 and half hours so first formula gives me 11.50 second formula gives me 1.50 for the hours before 7am
please help if you can i'm stuck
thanks
Tony
Just sorting out next years time sheet and i have a few problems,
I know time can be entered into excel as a time like "12:30:00"
but this is both difficult and slow so i want to be able to enter a start time and and end time as you do numbers so 10.00 to 14.45 for example
so this is what i need
Start time is in "D10"
End Time is in "E10" work out the hours worked as a decimal. so 3 and half hours is "3.50" etc
the another formula id possible to tell me how much time was before 7am?
so if you worked 5.30 till 17.00 thats 11 and half hours so first formula gives me 11.50 second formula gives me 1.50 for the hours before 7am
please help if you can i'm stuck
thanks
Tony