« Charting: Editing charts : part 3 | Main | Data Validation 101 »
January 16, 2005
Custom Time Formatting for a timesheet
In the timesheet example below, to represent the total hours worked for the week, we use a custom time format [H]:MMCells E3:E7 are also formatted similarly. If we had used HH:MM, E3 for example would display 07:15 - which is not quite what we are looking for.
Cells C3:D7 are formatted HH:MM AM/PM
Posted by Dave at January 16, 2005 02:23 AM
Comments
I'm trying to create a basic timesheet.
For E3 I get 0.33 if I use (D3-C3)
if I remove the ( ), I get nothing at all.
Also, I'd like to get 7.25 instead of 7:15
Really will appreciate your help with these.
THANK YOU
Posted by: Ron at November 11, 2005 10:15 AM
Calc, like Excel, computing time in measure of days.
So, any date and time will be represent like part of a day.
If you want to get 7.25 instead 7:15 do this:
=(D3-C3)*24
and set any of date formats in Format Cells.
Enjoy
Posted by: Igor Perković at November 19, 2005 06:03 AM