Thread: time
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sako 338 sako 338 is offline
external usenet poster
 
Posts: 15
Default time

That worked great. Thanks

"Max" wrote:

Assuming result cell is in A1,
Try in say, B1: =A1*24
Format B1 as general or number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sako 338" wrote:
how do i convert a difference between two times (say the result is 1:30 in
h:mm format) back to a number (1.5)

all help appreciated