subtracting units of time

[Glenn Ward]

Hi there,

I am trying to keep track of my hours at work, as I need to make up a day I
spend at hospital during the course a month. I have put together a sheet
(sort of a cut-down version of my department's timesheet), with day, month,
in and out. What I want to do is subtract 30 minutes from each standard
work day, so I end up with 8 (or however many hours worked) minus my half
hour lunch break.

Any help would be greatly appreciated.

Regards,
Glenn
Auckland, new Zealand

 

[David]

Glenn

Stick 0:30 in a cell and name it lunch_break.

Then use = A1-lunch_break, where A1 contains your times before subtration of
the 30 mins. Format all the relevant cells as hh:mm in Format | Cells |
Number, Custom tag

David