Software

Ask something
Discussion Locked

FORMULAS IN EXCEL

0 helpful
3 replies

by Member 31688719

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to know how to insert a formula that will tell me the delay in an activity.For e.g,a particular column has a "scheduled delivery date" and another column has "delay". I need excel to automatically enter the "delay " column taking the refernce from "scheduled delivery date" column.

Is there some formula that will cross check the date entered in the "scheduled Date" column and the system time and thereafter calculate the "delay" column ?

3 replies

by simy

Try:

=now()-A1

where A1 is the scheduled delivery date. Change the format of the "delay" column to number to give you the result in days.

by info

Use this:
formula in Delay Column is =IF(D2>A2,D2-A2,"On Time")

D2 = a now() column (formated with date and time)
A2 = Scheduled Delivery Date (formated with date and time)

If there is a delay the delay will be shown other wise "On Time" will be no delay shown.

by info

Also make sure to set the cells format to custom to the correct date time format that represents the kind of delays that will typically happen. time date calculations are converted to decimal numbers like .043234 so in certain functions of cells on dates/times, the result will be a decimal number instead the date or time you are expecting

This discussion is closed to new replies.