Crowland775
New Member
- Joined
- Jul 22, 2022
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I am attempting to subtract two cells for time remaining on an aircraft maintenance spreadsheet.
I am having trouble finding a formula that will allow me to subtract the total aircraft hours from the next inspection due.
D2: 4/30/1900 8:00:00 AM (2912:00) formatted with [h]:mm
E2: 4/29/1900 2:43:00 PM formatted with [h]:mm
F2: 5/3/1900 6:43:00 PM formatted with [h]:mm
G2: =SUM(D2-F2,"[h]:mm")
I am needing help formatting G2 to subtract the "end time" for the next inspection due from the current aircraft hours.
I should have a total of 82:43 hours in cell G2.
Please help!
I am having trouble finding a formula that will allow me to subtract the total aircraft hours from the next inspection due.
D2: 4/30/1900 8:00:00 AM (2912:00) formatted with [h]:mm
E2: 4/29/1900 2:43:00 PM formatted with [h]:mm
F2: 5/3/1900 6:43:00 PM formatted with [h]:mm
G2: =SUM(D2-F2,"[h]:mm")
I am needing help formatting G2 to subtract the "end time" for the next inspection due from the current aircraft hours.
I should have a total of 82:43 hours in cell G2.
Please help!