ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate gross pay (https://www.excelbanter.com/excel-discussion-misc-queries/36636-calculate-gross-pay.html)

Confused

Calculate gross pay
 
I enter start and end times (cell formated for time), subtract to find total
hours, and multiply by rate of pay. The result doesnt make any sense. What am
I doing wrong?

Niek Otten

Since time is stored as a fraction of a day, multiply your result by 24 and
format as anything but time, probably Currency

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Confused" wrote in message
...
I enter start and end times (cell formated for time), subtract to find
total
hours, and multiply by rate of pay. The result doesnt make any sense. What
am
I doing wrong?





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

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