count time format as decimal
 

Hi all,
B1
C1 D1
Is there a way to count two timevalues (start 22:00 and stop 01:15=3:15).
Get a value that works to multiply by i.e100, and receive the value 325?

I´m using Chip Pearsons worksheetcode for converting "1000" into "10:00" and
have the format as "t:mm"

//Thomas

count time format as decimal
 

assume 22:00 in B1, 01:15 in C1

in D1=MOD(C1-B1,1)*24*100

--
Regards,
Tom Ogilvy


"Jonsson" wrote in message
...
Hi all,
B1
C1 D1
Is there a way to count two timevalues (start 22:00 and stop 01:15=3:15).
Get a value that works to multiply by i.e100, and receive the value 325?

I´m using Chip Pearsons worksheetcode for converting "1000" into "10:00"
and
have the format as "t:mm"

//Thomas