I have a column with the hrs:min for start and another column with the hrs:min of end of an activity. it happens within same day.

Hrs are 0-24 and min are 0-59

If your data looks like this: A B C 1) Start End Diff 2) 8:30 13:15Simply use a formula that does a subtraction.

In C2 enter the formula =B2-A2You should get: 4:45

MIKE

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History