[算表]EXCEL 時間計算
軟體:EXCEL
版本:
有什麼公式可以計算超時加班?
例如:
22:00~6:00 是超時加班(實際起飛時間減掉預計起飛前的CHECK IN時間)
CHECK IN 時間為起飛前2小時
合約還要扣半小時
預計起飛時間 實際起飛時間 超時加班
2305 0150 3.5小時
1.21:05 CHECK IN/正在算超時加班從22:00
2.22:00~23:00
23:05~00:00
00:00~01:00
01:00~01:50(算至02:00)
共4個時間扣合約半小時所以是3.5小時
謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.45.125.48
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1461588753.A.DB6.html
※ 編輯: a196552000 (114.45.125.48), 04/25/2016 20:56:29
→
04/25 23:08, , 1F
04/25 23:08, 1F
→
04/25 23:50, , 2F
04/25 23:50, 2F
→
04/25 23:50, , 3F
04/25 23:50, 3F
→
04/25 23:50, , 4F
04/25 23:50, 4F
→
04/25 23:50, , 5F
04/25 23:50, 5F
→
04/25 23:50, , 6F
04/25 23:50, 6F
→
04/25 23:59, , 7F
04/25 23:59, 7F
→
04/26 00:00, , 8F
04/26 00:00, 8F
→
04/26 00:12, , 9F
04/26 00:12, 9F
→
04/26 00:12, , 10F
04/26 00:12, 10F
→
04/26 00:44, , 11F
04/26 00:44, 11F
→
04/26 07:16, , 12F
04/26 07:16, 12F
→
04/26 07:16, , 13F
04/26 07:16, 13F
→
04/26 07:16, , 14F
04/26 07:16, 14F
→
04/26 07:37, , 15F
04/26 07:37, 15F
→
04/26 07:39, , 16F
04/26 07:39, 16F
→
04/26 07:53, , 17F
04/26 07:53, 17F
→
04/26 08:07, , 18F
04/26 08:07, 18F
→
04/26 08:07, , 19F
04/26 08:07, 19F
→
04/26 08:14, , 20F
04/26 08:14, 20F
→
04/26 08:17, , 21F
04/26 08:17, 21F
→
04/26 08:20, , 22F
04/26 08:20, 22F
→
04/26 08:20, , 23F
04/26 08:20, 23F
→
04/26 08:20, , 24F
04/26 08:20, 24F
→
04/26 08:21, , 25F
04/26 08:21, 25F
→
04/26 08:25, , 26F
04/26 08:25, 26F
→
04/26 08:29, , 27F
04/26 08:29, 27F
→
04/26 12:49, , 28F
04/26 12:49, 28F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
