IF和TIME等函数计算停车费_精品文档.xls
《IF和TIME等函数计算停车费_精品文档.xls》由会员分享,可在线阅读,更多相关《IF和TIME等函数计算停车费_精品文档.xls(2页珍藏版)》请在冰豆网上搜索。
![IF和TIME等函数计算停车费_精品文档.xls](https://file1.bdocx.com/fileroot1/2022-10/14/98d6346c-b134-44f6-8879-fcab8cb990ea/98d6346c-b134-44f6-8879-fcab8cb990ea1.gif)
停车收费计算车车牌牌号号进进入入时时间间离离开开时时间间计计算算停停车车时时间间天天数数小小时时分分钟钟累累计计小小时时数数京AS17892006/11/59:
202006/11/512:
0002403京AS17902006/11/510:
302006/11/610:
50102024.5京AS17912006/11/513:
002006/11/518:
2005205.5京AS17922006/11/514:
002006/11/514:
1500150.5京AS17932006/11/513:
302006/11/517:
2003504京AS17942006/11/518:
002006/11/810:
00216064京AS17952006/11/611:
002006/11/619:
2808288.5京AS17962006/11/612:
402006/11/710:
300215022每每小小时时费费用用总总费费用用1030102451055105104010640108510220