I'm working on creating a weekly time sheet log. I have the formulas all set
up, but the total times need to be formated for quarter hours. (Where I need
it to show "7.5" it shows "7.30")
Thanks,
Cynthia
I'm working on creating a weekly time sheet log. I have the formulas all set
up, but the total times need to be formated for quarter hours. (Where I need
it to show "7.5" it shows "7.30")
Thanks,
Cynthia
You would have to convert to decimal hours for that, by multiplying by 24.
--
HTH
Bob Phillips
"C A" <[email protected]> wrote in message
news:[email protected]...
> I'm working on creating a weekly time sheet log. I have the formulas all
set
> up, but the total times need to be formated for quarter hours. (Where I
need
> it to show "7.5" it shows "7.30")
>
> Thanks,
> Cynthia
You would have to convert to decimal hours for that, by multiplying by 24.
--
HTH
Bob Phillips
"C A" <[email protected]> wrote in message
news:[email protected]...
> I'm working on creating a weekly time sheet log. I have the formulas all
set
> up, but the total times need to be formated for quarter hours. (Where I
need
> it to show "7.5" it shows "7.30")
>
> Thanks,
> Cynthia
You would have to convert to decimal hours for that, by multiplying by 24.
--
HTH
Bob Phillips
"C A" <[email protected]> wrote in message
news:[email protected]...
> I'm working on creating a weekly time sheet log. I have the formulas all
set
> up, but the total times need to be formated for quarter hours. (Where I
need
> it to show "7.5" it shows "7.30")
>
> Thanks,
> Cynthia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks