This formula works if elapsed time passes midnight...

=IF(AND(Start<"",Stop<""),ROUND(MOD(Stop-Start,1)*24,2),"")

..where 'Start' and 'Stop' are the defined name equivalent of your In_Time
and Out_Time, respectively.

Note that this formula is used for project time and so returns hours to 2
decimal places. Use 1440 to return minutes!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion