Thread
:
Identifing total hours as a whole number
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Identifing total hours as a whole number
Multiply the elapsed time by 24, (hours in a day) thus:
=(B1-A1)*24 and format as General or Number
or to calculate the pay:
=(B1-A1)*24* PAYRATE
and format a currency.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Bob Morrison" wrote in message
...
I have set up a little spreadsheet using "start time" and "end time". The
resulting difference is expressed in hours and minutes. I would like to
use this figure to calculate pay. It is not doing that because of the
formating. Is there a way?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann