Calculate gross pay

C

Confused

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?
 
N

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
 
Top