Calculating overdue by "Days" using dates

[Excelme at work]

Hi there, I have a schedule showing delivery information and would like to use a formula to show by how many days a delivery was either early or late.

I have previously used IF function to show if the delivered date cell is before or after the scheduled date cell.
But ideally i would like to show as either positive or negative number of days.
Is this possible?

Thanks in advance

 

[Special-K99]

Just subtract one date from the other for a date duifference (this assumes both dates ARE in fact dates and not text in any form).

A1 = scheduled date
B1 = delivery date

=B1-A1
If postive then its late, if negative then it's early

 

[Excelme at work]

Just subtract one date from the other for a date duifference (this assumes both dates ARE in fact dates and not text in any form).

A1 = scheduled date
B1 = delivery date

=B1-A1
If postive then its late, if negative then it's early

Thanks i had assumed that would work issue was with my cell formatting.
Taking it one step further would it be possible to calculate it as hours using Date and Time formt DD/MM/YY HH:MM
Scheduled - 12/01/2019 1300
Delivered - 13/01/2019 1700
Could i get an answer in decimal days or in hours with a separate function to /24 for decimal days.
Thanks

 

[Special-K99]

Time in Excel is from 0 to 1. 1 is full day (24 hrs), so 0.5 would be equal to 12 noon.
If you use Custom format [h]:mm:ss it will allow for hours over 24.
Otherwise you'd need a formula to break in down into days hours minutes seconds.

 

[excel_learnerz]

hey so with dates dd/mm/yyyy hh:mm:ss format so for example in column A you have scheduled date and in B you have Actual Delivery date to find out what is is
=(b2-a2)/0.04166
if its a minus its delivered early and if its positive its delivered late, and it will tell you how many hours its delievered late

 

[GR00007]

As Special-K99 mentioned, one day in a time field is by an increment of 1, so you could just format the difference as numeric with as many decimal places you want.

Here's your start and end dates with the difference displayed in [h]:mm:ss (28 hours)

Start	End	=End - Start
1/12/19 13:00	1/13/19 17:00	28:00:00

<tbody>
</tbody>

Here's the same data displayed as numeric with two decimals.

Start	End	End - Start
43477.54	43478.71	1.17

<tbody>
</tbody>

I would suggest leaving start/end formatted as date/time, but just wanted to show what the actual value of a date field is.