Board logo

¼ÐÃD: ¨D§U¡A¤u®ÉÂର¤Q¶i¦ì¨Ã­pºâ [¥´¦L¥»­¶]

§@ªÌ: alen022    ®É¶¡: 2014-8-5 11:58     ¼ÐÃD: ¨D§U¡A¤u®ÉÂର¤Q¶i¦ì¨Ã­pºâ

¦U¦ì¤j¤j¦n
¹J¨ì¤@­Ó°ÝÃD¡A­n½Ð±Ð¦U¦ì«e½ú
1.¤wª¾¤u®É 173:30  >>>®æ¦¡[h]:mm
2.­nÁÈ´«¦¨173.5®É>>>³o³¡¤À­n³]¬°­þ¤@ºØ®æ¦¡?
3.¨C¤p®É¤u¸ê135¤¸¡A¤u¸ê¦X­p=173.5X135
·PÁ¦U¦ì
§@ªÌ: ANGELA    ®É¶¡: 2014-8-5 21:26

¥»©«³Ì«á¥Ñ ANGELA ©ó 2014-8-6 22:46 ½s¿è

A1=¤wª¾¤u®É
=(LEFT(A1,LEN(A1)-3)+RIGHT(A1,2)/60)*135

«¢«¢¡F¥H¬°¬O¤å¦r®æ¦¡¡C¨S±a¦Ñªá²´Ãè¡C
§@ªÌ: alen022    ®É¶¡: 2014-8-6 09:25

¦^´_ 2# ANGELA

¤j¤j±z¦n
·PÁ¦^´_¡A§Ú¦³¸Õ¤F¡A¦ýµª®×¤£¹ï°Ç@@
¤£ª¾¹D¨ºùØ¿ù¤F
§Úªº¤wª¾¶µ¥Ø¦bG47¡A©Ò¥H§Ú§â§A¦¡¤l¤¤ªºA1´«¦¨G47
§@ªÌ: Hsieh    ®É¶¡: 2014-8-6 09:49

¦^´_ 3# alen022

[attach]18835[/attach]
§@ªÌ: ML089    ®É¶¡: 2014-8-6 11:21

¦^´_ 1# alen022

>>¦U¦ì¤j¤j¦n
>>¹J¨ì¤@­Ó°ÝÃD¡A­n½Ð±Ð¦U¦ì«e½ú
>>1.¤wª¾¤u®É 173:30  >>>®æ¦¡[h]:mm
>>2.­nÁÈ´«¦¨173.5®É>>>³o³¡¤À­n³]¬°­þ¤@ºØ®æ¦¡?
>>3.¨C¤p®É¤u¸ê135¤¸¡A¤u¸ê¦X­p=173.5X135
>>·PÁ¦U¦ì
   
EXCEL ¤é´Á®É¶¡´N¬O¥H¤Ñ(¤é)¬°³æ¦ì
¤u®É 173:30  >>>®æ¦¡[h]:mm¡A­YÂର³q¥Î®æ¦¡®ÉÅã¥Ü 7.22916666666667 (¤Ñ)¡A­nÂର¤p®É¬°³æ¦ì®É ´N¬O ¤u®É*24´N¥i¥H

²³æ¨ÓÁ¿ ¤u¸ê¦X­p = ¤u®É(¤Ñ¬°³æ¦ì) * 24¤p®É/¤Ñ * 135¤¸/¤p®É
§@ªÌ: alen022    ®É¶¡: 2014-8-6 12:41

·PÁ¼ӤWªº¦U¦ì¤j¤j
¤w¸g¶¶§Q¸Ñ¨M
´ª·P¤ß




Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)