Time Formats

[Tim_Whyte]

I'm setting up a time sheet and I'm looking for a formula that will convert total hours worked in a day from the h:m format to a h.m format. For example if an employee works 6:30 hours then it would read 6.5 hours.

Any ideas?

 

[Aladin Akyurek]

On 2002-09-20 10:14, Tim_Whyte wrote:
I'm setting up a time sheet and I'm looking for a formula that will convert total hours worked in a day from the h:m format to a h.m format. For example if an employee works 6:30 hours then it would read 6.5 hours.

Any ideas?

=A1*24

where A1 houses a time value like 6:30.

Format the formula cell as General.

 

[Mark W.]

You may need to format as...

0.0

 

[backpacker]

Trying to expand on this.
I have a job expense sheet which I try to track regular hours and overtime hours. Right now I am filling in those manually. I can get a total hours using the above mentioned. How can I split it so hours from 8-4:30pm show up as regular and everything else as overtime.
Thanks

 

[Mark W.]

What's overtime? Anything over 8 hrs? Like this...

Book2
	A	B	C	D	E	F	G	H
1	Begin	End	Regular	Overtime
2	8:00	16:30	8	0.5
3
4
5
Sheet1

This message was edited by Mark W. on 2002-09-20 12:36