Subtracting Times with dates
=B1-A1
Custom format: [h]:mm
"Tstewart14" wrote:
I have 4 colums on for start date one for start time one for end date and one
for end time
I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00
|