| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
time
Multiply with 24 and set the Number format to general.
HTH Kostis Vezerides 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
time
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
time
Glad to hear that !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "sako 338" wrote in message ... That worked great. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Hot key for time? | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Entering Times | Excel Discussion (Misc queries) | |||
Linear Mode
