ExcelBanter - CONVERT HOURS AND MINUTES TO INT

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CONVERT HOURS AND MINUTES TO INT (https://www.excelbanter.com/excel-discussion-misc-queries/207728-convert-hours-minutes-int.html)

3Nails

CONVERT HOURS AND MINUTES TO INT

Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?

Peo Sjoblom[_2_]

CONVERT HOURS AND MINUTES TO INT

Multiply by 24 and format as general or number

=A2*24

--

Regards,

Peo Sjoblom

"3Nails" wrote in message
...
Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?

ijustlivehere

CONVERT HOURS AND MINUTES TO INT

What if I go over midnight?

"Peo Sjoblom" wrote:

Multiply by 24 and format as general or number

=A2*24

--

Regards,

Peo Sjoblom

"3Nails" wrote in message
...
Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?

Fred Smith[_4_]

CONVERT HOURS AND MINUTES TO INT

See your other post.

Regards,
Fred

"ijustlivehere" wrote in message
...
What if I go over midnight?

"Peo Sjoblom" wrote:

Multiply by 24 and format as general or number

=A2*24

--

Regards,

Peo Sjoblom

"3Nails" wrote in message
...
Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?

All times are GMT +1. The time now is 04:20 PM.