suppose the data is in A2 & B2 column then putting below formula in C
column you will get 1.75.............
=(B2-A2)*24
A B C
13:00 14:45 (B2-A2)*24 = 1.75
--
mubashir aziz
------------------------------------------------------------------------
mubashir aziz's Profile:
http://www.thecodecage.com/forumz/member.php?userid=237
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=86072