§Q¥Î®É¬q¬Û®t­pºâ¥I¶O¦h¤Ö

K_Wing

§Ú·Q½Ð±Ð¦U¦ì«e½ú
¦³¨S¦³¤èªk§Q¥Î¥H¤U´£¨Ñªº±ø¥ó
­pºâ¥XÁ`ÃB
¦]ªí®æ¤º¥u´£¨Ñ®É¬q
¨S¦³´£¨Ñ¨Ï¥Î·|ij«Ç¦h¤Ö¤p®É
©Ò¥H·Q°Ý°Ý¥i§_§Q¥Î¸Ó­Ó®É¬q§@¥X­pºâ

	A	B	C	D	E	F
1	¤é´Á	®É¬q	·|ij«ÇA/B/C	¨C¤p®É¦¬¶O	§é¦©	Á`ÃB
2	12/12/2014	16:00 - 18:00	·|ij«ÇA	$1000.00	10%	1800.00
3

p212

¦^´_ 1# K_Wing
Àx¦s®æF2¿é¤J
=(TIMEVALUE(RIGHT(B2,5))-TIMEVALUE(LEFT(B2,5)))*24*D2*(1-E2)
½Ð°Ñ¦Ò¡I

K_Wing

¦^´_  K_Wing
Àx¦s®æF2¿é¤J
=(TIMEVALUE(RIGHT(B2,5))-TIMEVALUE(LEFT(B2,5)))*24*D2*(1-E2)
½Ð°Ñ¦Ò¡I
p212 µoªí©ó 2014-12-12 16:56

«D±`·PÁ«e½ú

·Q¦A½Ð±ÐRIGHT(B2,5)
¨º­Ó"5"¬O¥Nªí¬Æ»ò¡H

p212

¦^´_ 3# K_Wing
hh:mm¡A¦@¦³5­Ó¦r¤¸¡A¬GÀx¦s®æB2¦Û¥kºI¨ú(²×¤î®É¶¡ÂI¡^©Î¦Û¥ªºI¨ú¡]¶}©l®É¶¡ÂI¡^ªº¡u®É¶¡¡v¸ê®Æ¦r¤¸¬Ò¬°¡u5¡v¡C
½Ð°Ñ¦Ò¡I

K_Wing

¦^´_ 4# p212
­ì¨Ó¬O5­Ó¦r¤¸
¯uªº«D±`·P¿E

¦ý§Ú¤´¦³¤£©ú¤§³B

	A	B	C	D	E	F
1	¤é´Á	®É¬q	·|ij«ÇA/B/C	¨C¤p®É¦¬¶O ¨C®É¬q¦¬¶O (¨C¤T¤p®É¦¬¶O)	§é¦©	Á`ÃB
2	12/12/2014	13:00 - 18:00	·|ij«ÇA	$200.00	0	$400.00
3

°²³]¤£¥H®É¬q¨Ó­pºâ
¦Ó§ï¬°¤@¸`¤T¤p®É
¨C¤T¤p®É¦¬¶O¬°$200.00
¤£¨¬¤T¤p®É¥ç§@¤T¤p®É­pºâ
¨º»ò¥i¥H«ç¼Ë­×§ï©O?

p212

¦^´_ 5# K_Wing
Àx¦s®æF2¿é¤J
=CEILING((TIMEVALUE(RIGHT(B2,5))-TIMEVALUE(LEFT(B2,5)))*24,3)/3*D2
½Ð°Ñ¦Ò¡I

K_Wing

¦^´_  K_Wing
Àx¦s®æF2¿é¤J
=CEILING((TIMEVALUE(RIGHT(B2,5))-TIMEVALUE(LEFT(B2,5)))*24,3)/3*D2
½Ð°Ñ ...
p212 µoªí©ó 2014-12-15 08:15

:) «Ü¦n
«Ü¦³®Ä
¦A¤@¦¸«D±`·P¿E