time calculate formula

Type the times in two different cells.now in another cell type the formula =minute(first cell reference-second cell reference).you will get the answer in minutes.but this formula gives you the answer only if the difference is within 60 .if it exceeds 60,then the formula is =(first cell reference-second cell reference).

example:

B4=10:40

C4=10:00

then the formula is =minute(B4-C4),the ans is 40

if B4=11:40

C4 is =10:00

then the formula is =(B4-C4)*1440,the ans is 100.

if B4 =10:40,C4=10:00,the formula is =minute(B4-C4),the ans is 40.(this formula is used if the difference is within 60 minutes)

if B4=11:40,C4=10:00,the formula is =(B4-C4)*1440,the ans is 100(this formula is used if the difference is more than 60)