スポンサードリンク | |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 909 | 1705 | |
4 | 1108 | 1613 | |
5 | 1004 | 1709 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 909 | 1705 | 7:56 |
4 | 1108 | 1613 | 5:05 |
5 | 1004 | 1709 | 7:05 |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 909 | 1705 | =TIME(INT(C3/100),MOD(C3,100),0)-TIME(INT(B3/100),MOD(B3,100),0) |
4 | 1108 | 1613 | =TIME(INT(C4/100),MOD(C4,100),0)-TIME(INT(B4/100),MOD(B4,100),0) |
5 | 1004 | 1709 | =TIME(INT(C5/100),MOD(C5,100),0)-TIME(INT(B5/100),MOD(B5,100),0) |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 909 | 1705 | =TEXT(C3,"0!:00")-TEXT(B3,"0!:00") |
4 | 1108 | 1613 | =TEXT(C4,"0!:00")-TEXT(B4,"0!:00") |
5 | 1004 | 1709 | =TEXT(C5,"0!:00")-TEXT(B5,"0!:00") |
B | C | D | |
2 | 入場時刻 | 退場時刻 | 滞在時間 |
3 | 909 | 1705 | =((INT(C3/100)*60+MOD(C3,100))-(INT(B3/100)*60+MOD(B3,100)))/1440 |
4 | 1108 | 1613 | =((INT(C4/100)*60+MOD(C4,100))-(INT(B4/100)*60+MOD(B4,100)))/1440 |
5 | 1004 | 1709 | =((INT(C5/100)*60+MOD(C5,100))-(INT(B5/100)*60+MOD(B5,100)))/1440 |
スポンサードリンク
PageViewCounter
Since2006/2/27