cell format for hours

clausboss

Board Regular
Joined
Sep 13, 2005
Messages
71
Hi

I have tryed to make time sheet, wher i type in the time when i start working and the time when I am done.

I then want to have the system calculat the hours.

I have found a format wher i have to type 08:00 16:00 but can i pre define so I just can type 800 to 1600 or 0800 to 1600 then the system knows that it is 08:00 to 16:00?

This is a basic exel question:(

Claus
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,118,278
Messages
5,571,276
Members
412,374
Latest member
Nagelgal
Top