How do you calculate the difference between two time fields in MS Excel to a value that is in minutes +/-

Hello,
I have two fields (a1 and a2) time format and I need to calculate the difference in the times to a +/- values in minutes (a3 value)

e.g.
a1 09:03
a2 09:07
a3 -3.75 (obviously the seconds field factored in here)
groovymonkeyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
=(A1-A2)*24*60

for example.
0
All Courses

From novice to tech pro — start learning today.