making a time a measurement of time, not an hour of the day??

[small tom]

I am creating a timesheet (from a tutorial in a mag) and have the clock
in time, clock out time and break. Clock in and out are times of the
day - fine. The break time is a measurement of time, eg, 1hour, rather
than a specific time, eg, 1.00am. I cannot seem to make the break
setting a measurement of time (even though I have followed the tutorial
to the letter).

How do I set the break to be a measurement of time?

Am using Office Mac 2004.

Thanks in advance

Tom

 

[Bob Phillips]

Presumably you have subtracted the clock-in time from the clock-out time.
Just multiply that result by 24 as Excel stores time as a fraction of 1 day,
and format it as General.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

I am creating a timesheet (from a tutorial in a mag) and have the clock
in time, clock out time and break. Clock in and out are times of the
day - fine. The break time is a measurement of time, eg, 1hour, rather
than a specific time, eg, 1.00am. I cannot seem to make the break
setting a measurement of time (even though I have followed the tutorial
to the letter).

How do I set the break to be a measurement of time?

Am using Office Mac 2004.

Thanks in advance

Tom

Just format the cell as h:mm or [h]:mm
Format/Cells/Number/Custom Type: ____

It will appear properly in the cell.

You cannot change it's appearance in the formula bar.
--ron

 

[small tom]

Sorry, I obviously did not explain myself very well. I have alread
subtracted the clock in time from clock out etc and that all works fin
but when I input my break time (eg, 0:45 for 45mins) it changes it t
12.45am and therefore I cannot subtract this from the total and get
nice neat "hours worked" sum.

I need to know how to make 0:45 equate to 45mins rather than 12.45am.

Cheers

To

 

[Bob Phillips]

Format that as hh:mm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[small tom]

Thanks for that - had already tried it and it was not working but as it
turns out, I had another error elsewhere. All sorted now ta.

Cheers

Tom

 

[David McRitchie]

Hi Tom,
and since it looks like you will probably needing additional help with
understanding and using date and time suggest you look over
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/excel.htm

You might also keep the format [hh]:mm or [h]:mm
in mind to keep hours from overflowing into days when
you add up a column of times.

 

[small tom]

Much appreciated!