![]() |
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? |
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