Difference in Time
 

I did a search on this topic and the solutions given for some reason don't
work for me.

I need a simple formula that will give me a difference between two times
(for instance, between 2:00 and 1:30 being 0:30).

One formula I found was =(A1-B1)*24 but it did not work. Any suggestions?

Difference in Time
 

=A1-B1 with cells formatted as hh:mm

"jmj713" wrote:

I did a search on this topic and the solutions given for some reason don't
work for me.

I need a simple formula that will give me a difference between two times
(for instance, between 2:00 and 1:30 being 0:30).

One formula I found was =(A1-B1)*24 but it did not work. Any suggestions?

Difference in Time
 

Yup, just tried that myself and voila! The *24 part threw me off...

"Toppers" wrote:

=A1-B1 with cells formatted as hh:mm

"jmj713" wrote:

I did a search on this topic and the solutions given for some reason don't
work for me.

I need a simple formula that will give me a difference between two times
(for instance, between 2:00 and 1:30 being 0:30).

One formula I found was =(A1-B1)*24 but it did not work. Any suggestions?