Timesheet problem

J

John P

Dear All,

I would like to create a leave planner sheet which calculates my hours
remaining.

Problems occur when I enter the actual hours eg 7:24 (for a working day) is
ok BUT entering 133:30 hours to start with gives me a date and an eroneous
time!

I have formatted the cell to [h]:mm but for some reason this gives me -
05/01/1900 13:02:00 as an entry.

Beyond this I would like to incrementally reduce the balance when time
off/leave is taken.

Any help would be gratefully received.

Cheers


John
North Yorkshire

XP Pro
Excel 2003
 
F

Frank Kabel

Hi
if I enter 133:30 in Excel (with your custom format) the
cell shows '133:30'. Only the formula bar shows it as a
date (rule: 1 day = 1 as integer value = 24 hours)
 
J

John P

Thanks Hans and Frank.

Job sorted - now sticking hair back in head!!

Cheers

John
Frank Kabel said:
Hi
if I enter 133:30 in Excel (with your custom format) the
cell shows '133:30'. Only the formula bar shows it as a
date (rule: 1 day = 1 as integer value = 24 hours)

-----Original Message-----
Dear All,

I would like to create a leave planner sheet which calculates my hours
remaining.

Problems occur when I enter the actual hours eg 7:24 (for a working day) is
ok BUT entering 133:30 hours to start with gives me a date and an eroneous
time!

I have formatted the cell to [h]:mm but for some reason this gives me -
05/01/1900 13:02:00 as an entry.

Beyond this I would like to incrementally reduce the balance when time
off/leave is taken.

Any help would be gratefully received.

Cheers


John
North Yorkshire

XP Pro
Excel 2003


.
Click to expand...
Click to expand...
 
Top