ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - time (https://www.excelbanter.com/excel-worksheet-functions/126273-time.html)

sako 338

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

vezerid

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

Max

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

sako 338

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

Max

time

Glad to hear that !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sako 338" wrote in message
...
That worked great. Thanks

All times are GMT +1. The time now is 05:07 PM.