ExcelBanter - Get excel to fractionalize hours.

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

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

- - Get excel to fractionalize hours. (https://www.excelbanter.com/excel-discussion-misc-queries/3744-get-excel-fractionalize-hours.html)

ghoward777

Get excel to fractionalize hours.

I am making a time sheet for employees. Make 10:00 AM (one cell) to 12:30 PM
(2nd cell) = 2.5 hrs etc.....

Peo Sjoblom

=(B2-A2)*24

format as general

Regards,

Peo Sjoblom

"ghoward777" wrote:

I am making a time sheet for employees. Make 10:00 AM (one cell) to 12:30 PM
(2nd cell) = 2.5 hrs etc.....

All times are GMT +1. The time now is 02:24 PM.