tarheel4ever
New Member
- Joined
- Apr 5, 2016
- Messages
- 7
hello,
I am using excel to create a spreadsheet to calculate total time between the two dates. One date is Actual date and time, the second is the System's date and time, and the third is the incident date and time. If system time is less than Actual date i subtract to find total time to find the correct time for the incident date and time.
=IF(Actual_Time>System_Time,INT(Actual_Time-System_Time) & " days, " & HOUR(Actual_Time-System_Time) & " hours, " & MINUTE(Actual_Time-System_Time) & " minutes ",INT(System_Time-Actual_Time) & " days, " & HOUR(System_Time-Actual_Time) & " hours, " & MINUTE(System_Time-Actual_Time) & " minutes ")
This formula is to find total time difference (D4). Format custom: yy" years" m" months" d" days" m" hours"h" minutes"
=IF(System_Time<Actual_Time,Actual_Time-System_Time,"") (A8) Format custom: yy "years", m" months", dd" days", hh "hours", mm" minutes"
This is used to reference the Incident time .
=IF(System_Time<Actual_Time,Actual_Time-System_Time,"") (D12) Format: mm/dd/yyy HH:MM
A8 is still showing 1 month in the calculations what am i doing wrong? I have file to upload if needed
I am using excel to create a spreadsheet to calculate total time between the two dates. One date is Actual date and time, the second is the System's date and time, and the third is the incident date and time. If system time is less than Actual date i subtract to find total time to find the correct time for the incident date and time.
=IF(Actual_Time>System_Time,INT(Actual_Time-System_Time) & " days, " & HOUR(Actual_Time-System_Time) & " hours, " & MINUTE(Actual_Time-System_Time) & " minutes ",INT(System_Time-Actual_Time) & " days, " & HOUR(System_Time-Actual_Time) & " hours, " & MINUTE(System_Time-Actual_Time) & " minutes ")
This formula is to find total time difference (D4). Format custom: yy" years" m" months" d" days" m" hours"h" minutes"
=IF(System_Time<Actual_Time,Actual_Time-System_Time,"") (A8) Format custom: yy "years", m" months", dd" days", hh "hours", mm" minutes"
This is used to reference the Incident time .
=IF(System_Time<Actual_Time,Actual_Time-System_Time,"") (D12) Format: mm/dd/yyy HH:MM
A8 is still showing 1 month in the calculations what am i doing wrong? I have file to upload if needed