G
Guest
I have a spreadsheet for towed vehicles. If I have an IN Column that has a
date and time and an OUT column that has a date and time released. I also
have a column that has amounts of charges ($45.00 per day) In the third
column I would like a calculation based on the In and Out times: Example, if
a vehicle is picked up before 2 hours, there is no charge, after 2 hours the
same day, 1 day of storage is charged. If a vehicle is picked up the next
day before 1400 hrs - one day charged, but if the vehicle is picked up 1401
hrs - two days storage is charged. etc.
Is there a formula that would calculate based on the hours and days? Thanks,
date and time and an OUT column that has a date and time released. I also
have a column that has amounts of charges ($45.00 per day) In the third
column I would like a calculation based on the In and Out times: Example, if
a vehicle is picked up before 2 hours, there is no charge, after 2 hours the
same day, 1 day of storage is charged. If a vehicle is picked up the next
day before 1400 hrs - one day charged, but if the vehicle is picked up 1401
hrs - two days storage is charged. etc.
Is there a formula that would calculate based on the hours and days? Thanks,