format a cell for a timesheet

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

What format should I use if I want the time sheet to show
totals in quarter hours such as 8:25 instead of 8:15.

The current format is [H]:mm and it's returning the 8:15
but I want it to return 8:25


Thank you

Louis
 
Louis,

In an adjacent column, use = A1*24 and format to dec places. You will get
8.25, not 8:25, but is that okay?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
-----Original Message-----
Louis,

In an adjacent column, use = A1*24 and format to dec places. You will get
8.25, not 8:25, but is that okay?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

What format should I use if I want the time sheet to show
totals in quarter hours such as 8:25 instead of 8:15.

The current format is [H]:mm and it's returning the 8:15
but I want it to return 8:25


Thank you

Louis
Click to expand...


.
can you be a little bit more explicit. what does A1
Click to expand...
represent?

Louis
 
-----Original Message-----
Louis,

In an adjacent column, use = A1*24 and format to dec places. You will get
8.25, not 8:25, but is that okay?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

What format should I use if I want the time sheet to show
totals in quarter hours such as 8:25 instead of 8:15.

The current format is [H]:mm and it's returning the 8:15
but I want it to return 8:25


Thank you

Louis
Click to expand...


.
ok...I got it...thank you
Click to expand...

Louis
 
Back
Top