A simple alternative

A1: 23:00
B1: 00:15
=MOD(B1-A1,1)

in general
=Mod(endtime-starttime,1)


format the cell as time
--
Regards,
Tom Ogilvy

"Ron - Matrix Investigations"
wrote in message
...
Thanks, I really appreciate the help.

Ron
805-529-8300

"daddylonglegs" wrote:


Is this in one cell or two?

Ideally, if you enter times with a colon i.e. in A1 23:00 and in B1
00:15 then the formula for showing the difference in time is

=B1-A1+(A1B1)

format as time

this will give you

01:15

or if you want 1.25

=(B1-A1+(A1B1))*24

format as number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=508391