Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / July 2007

Tip: Looking for answers? Try searching our database.

Time calculations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pammy - 10 Jul 2007 19:38 GMT
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,
DaveG - 18 Jul 2007 21:40 GMT
Look up "IF" commands then create a column that takes your input data and
multiplies it by the "IF" output.  Example =45*IF(T<=2,[Zero],IF(T<=14,1,2)).

> 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
[quoted text clipped - 5 lines]
> hrs - two days storage is charged.  etc.
> Is there a formula that would calculate based on the hours and days?  Thanks,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.