Date Format

[@tul]

Creation Date Resolved Date Date Difference
2/10/2016 12:32 2/23/2017 16:49 13-04:17

There is total 379 days but "DD-HH:MM" shown only 13 days

Not getting Why

 

[deciog]

Checks cell number formatting

 

[@tul]

Checks cell number formatting

Hi

Thanks but I want this Answer"379-4:17" when I deduct resloved Date to Creation Date in "DD-HH:MM" format.

please help me out in this.

Thanks

 

[deciog]

Check if it is this way

 

[@tul]

Check if it is this way

Hi Deciog,

Thanks for Prompt reply.

I am attaching a sheet with one more query.

Actually have a thousands of this Creation and resolved date, so i want average at the end which is not possible if we put any string through conct.

Please look sheet

Thanks

 

[deciog]

I averaged only with the days, this is the way you want

 

[@tul]

Hi Decioq,

Please look one more time in attached sheet

 

[deciog]

Sorry, I was able to format the cell but not the averaged, check

 

[vletm]

@tul
How to make average of two strings? like "AAA" & "CCC" ... good question!
Syntax:
AVERAGE(number1, [number2], ...)
The AVERAGE function syntax has the following arguments:
Number1 Required. The first number, cell reference, or range for which you want the average.
Number2, ... Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.
Check this...