Changing Colon by Period for calculating time card.

[serge]

I would like to change on the time card the way the formula calculate the time worked by, instead of writing the hour with a colon, writing them with a period and also the hours would be written differently as this example :

9:00 = 9
9:15 = 9.25
9:30 = 9.50
9:45 = 9.75
10:00 = 10

See table below, in yellow is what I need if it's possible ?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Rate	Per ( Hour )	Start	1st MEAL 2nd MEAL		Dismissal	Total Hours Worked	Straight for	x 1.5 for	x 2 after	Total $ per day
2	$15.50	1						8:00	4:00	12:00
3
4
5	Monday	5/18/11	6:15	12:30	13:45	21:45	14:15	8:00	4:00	2:15	$ 286.75
6
7
8	Tuesday		6.25	12.50	13.75	21.75	14.25	8	4	2.25	$286.75
9
10
Sheet

Thank you.

 

[Warship]

Something like:

=(A1-INT(A1))*24

A1 is your time value

 

[serge]

Maybe, but I need the formula to fit the cells that need to be change, because I'm not an Excel expert.

 

[Nalani]

Try this if G5

=IF(F5="","",(F5-C5-(E5-D5)-(E6-D6))*24)

See if you can adapt for the others.

 

[serge]

I was able to adapted cells : G,H,I and those works, but changing the other one would not give the right answer !!!

I also need to put the hours in C,D,E,F with a period (.) and not a colon ) would the formula calculate it right ??

 

[Nalani]

Format your cells to General

 

[Nalani]

Maybe this link will help you out with working with Time

http://www.contextures.com/xlfaqDat.html

 

[Nalani]

Here's another link that also has a Downloadable workbook for you (towards the Bottom)

http://www.cpearson.com/excel/overtime.htm

 

[serge]

Thank you Nalani,

I will look at the link you sent me and see, if I can fix my formulas.

Best Regards...
Serge.