スポンサードリンク | |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 9:09 | 17:05 | |
4 | 9:08 | 17:13 | |
5 | 9:04 | 17:09 | |
6 | 合計 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 課金時間 |
3 | 9:10 | 11:40 | |
4 | 11:04 | 12:30 | |
5 | 10:50 | 13:15 | |
6 | 12:10 | 14:10 | |
7 | 13:05 | 14:48 |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | |
4 | 11:04 | 12:30 | |
5 | 10:50 | 13:15 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 9:09 | 17:05 | 7:56 |
4 | 9:08 | 17:13 | 8:05 |
5 | 9:04 | 17:09 | 8:05 |
6 | 合計 | 24:06 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 9:09 | 17:05 | =C3-B3 |
4 | 9:08 | 17:13 | =C4-B4 |
5 | 9:04 | 17:09 | =C5-B5 |
6 | 合計 | =SUM(D3:D5) |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 9:09 | 17:05 | =(ROUND(C3*1440,0)-ROUND(B3*1440,0))/1440 |
4 | 9:08 | 17:13 | =(ROUND(C4*1440,0)-ROUND(B4*1440,0))/1440 |
5 | 9:04 | 17:09 | =(ROUND(C5*1440,0)-ROUND(B5*1440,0))/1440 |
6 | 合計 | =SUM(D3:D5) |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 9:09 | 17:05 | =TEXT(C3-B3,"h:mm")*1 |
4 | 9:08 | 17:13 | =TEXT(C4-B4,"h:mm")*1 |
5 | 9:04 | 17:09 | =TEXT(C5-B5,"h:mm")*1 |
6 | 合計 | =SUM(D3:D5) |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 課金時間 |
3 | 9:10 | 11:40 | 2:30 |
4 | 11:04 | 12:30 | 0:56 |
5 | 10:50 | 13:15 | 1:25 |
6 | 12:10 | 14:10 | 1:10 |
7 | 13:05 | 14:48 | 1:43 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 課金時間 |
3 | 9:10 | 11:40 | =MAX(0,MIN("12:00",C3)-B3)+MAX(0,C3-MAX("13:00",B3)) |
4 | 11:04 | 12:30 | =MAX(0,MIN("12:00",C4)-B4)+MAX(0,C4-MAX("13:00",B4)) |
5 | 10:50 | 13:15 | =MAX(0,MIN("12:00",C5)-B5)+MAX(0,C5-MAX("13:00",B5)) |
6 | 12:10 | 14:10 | =MAX(0,MIN("12:00",C6)-B6)+MAX(0,C6-MAX("13:00",B6)) |
7 | 13:05 | 14:48 | =MAX(0,MIN("12:00",C7)-B7)+MAX(0,C7-MAX("13:00",B7)) |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | 800 |
4 | 11:04 | 12:30 | 500 |
5 | 10:50 | 13:15 | 800 |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | =ROUNDUP((C3-B3)/"0:20",0)*100 |
4 | 11:04 | 12:30 | =ROUNDUP((C4-B4)/"0:20",0)*100 |
5 | 10:50 | 13:15 | =ROUNDUP((C5-B5)/"0:20",0)*100 |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | =ROUNDUP(ROUND((C3-B3)*1440,0)/20,0)*100 |
4 | 11:04 | 12:30 | =ROUNDUP(ROUND((C4-B4)*1440,0)/20,0)*100 |
5 | 10:50 | 13:15 | =ROUNDUP(ROUND((C5-B5)*1440,0)/20,0)*100 |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | =ROUNDUP(TEXT(C3-B3,"[m]")/20,0)*100 |
4 | 11:04 | 12:30 | =ROUNDUP(TEXT(C4-B4,"[m]")/20,0)*100 |
5 | 10:50 | 13:15 | =ROUNDUP(TEXT(C5-B5,"[m]")/20,0)*100 |
B | C | D | |
2 | 入車時刻 | 出車時刻 | 駐車料金 |
3 | 9:10 | 11:40 | =CEILING((C3-B3)*1440*5,100) |
4 | 11:04 | 12:30 | =CEILING((C4-B4)*1440*5,100) |
5 | 10:50 | 13:15 | =CEILING((C5-B5)*1440*5,100) |
スポンサードリンク
PageViewCounter
Since2006/2/27