hour format

[Geo]

i pretty useless at excel, but im wondering is it possible to format a colum
so that excel recongises that colum as hours. ive to setup a spread sheet
for the number of hours worked and i want excel to know if i input say 37.5
hours, it will know that its hours and not days or minutes.

is this possible

sorry for sounding dumb

 

[Dave Peterson]

Not by formatting, but you could have a macro that converts your input to time.

Chip Pearson has some code at:
http://www.cpearson.com/excel/DateTimeEntry.htm

And you may want to read more about how excel deals with time (and dates):
http://www.cpearson.com/excel/datetime.htm