macro to work out number of hours and minutes worked and convert into decimal, and if possible how many were before a set time?

[tonywatsonhelp]

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

 

[lrobbo314]

Like this...

Book1
	D	E	F	G	H	I
9	Start	End	Total	Hrs Before 7	Total Time	Time Minus Before 7
10	5.50	17.00	11.50	1.50	11 hrs 30 min	10 hrs 00 min
Sheet2

Cell Formulas
Range	Formula
F10	F10	=E10-D10
G10	G10	=7-D10
H10	H10	=(F10*((1/24/60)*60))
I10	I10	=(F10-G10)*((1/24/60)*60)

Cell G10 has a custom format

hh \h\r\s mm \mi\n