How to calculate Aging with hours and days

[Learn Excel in Tamil]

Hi

[FONT=&quot]We are working till 3:30AM and Networkday formula doesn't consider time.[/FONT]

[FONT=&quot]1) If we receive a request on Friday after 12:00AM or 1:00AM it'll be considered as Saturday and Networkday formula does not consider this.[/FONT]

[FONT=&quot]2) * If a request was submitted on 11:30PM and completed at 12.30AM it'll show two days, but actual time taken is 1hour[/FONT]
[FONT=&quot]* If a request was submitted on 12:01 AM and completed on next day 11:59PM still it shows 2 days. actual time taken is almost 48 hour.[/FONT]

[FONT=&quot]Is there any way we can count the time too.[/FONT]

 

[iggy_]

How is your data set up because if you have it in a time format with the date, you can just subtract the two numbers. Alternatively if dates are in separate columns you would just add up the difference in days and difference in time.

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td][/td][td][/td][td][/td][td]Hrs[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

5/5/18 23:30​

[/td][td]

5/6/18 0:30​

[/td][td][/td][td]

1​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

5/5/18 0:01​

[/td][td]

5/6/18 23:59​

[/td][td][/td][td]

47.96667​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet11[/td][/tr][/table]

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

D​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

=(B12-A12)*24​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet11[/td][/tr][/table]