ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert Time to Number (https://www.excelbanter.com/excel-discussion-misc-queries/211708-convert-time-number.html)

CRBI

Convert Time to Number
 
I know there's a simple solution here but I don't know what it is. I have a
spreadsheet where I have created from-to times in. This is going to loosely
serve as a time sheet. Now I want to calculate the difference between the
two times to get the number of hours worked, then I want to multiply that by
the rate of pay. I have the following fields: In Time, Out Time, Total
Hours, Total Pay. The problem is, I need to be able to convert the different
in the In Time and Out time to a number once it's calculated so as to
correctly multiply by the rate of pay. For instance, if the In Time is 9:00
and the Out time is 11:30, that calculates time-wise as 2.30 which is
correct. However, to multiply it by the rate of pay, it would need to read
2.50. Any help is appreciated. I'm sure there's a simple code I can insert
somewhere to do this conversion.

Gary''s Student

Convert Time to Number
 
With 9:00 in A1 and 11:30 in A2, in A3 enter:
=24*(A2-A1) and format as General.
--
Gary''s Student - gsnu200816


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com