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]:MM
Cells 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
July 26th, 2007 at 11:41 pm
How to convert time format to number? for example I want to make a billing system using Calc?
______________________________________________________
| Start | Finish | Duration | Bill @ Hour | Total Bill |
______________________________________________________
| 08:00AM | 10:00AM | 02:00 | USD$0.80 | USD$????? |
______________________________________________________