Hrs & Duration

pukenzz

New Member
Joined
Jun 29, 2015
Messages
35
Trying to capture time, elapsed time, duration however you want to look at it. I want to be able to enter it to the nearest 1/4hr

4 hrs 00 min
4 hrs 15 min
4 hrs 30 min
4 hrs 45 min

I'm not able to get this to work correctly.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

pukenzz

New Member
Joined
Jun 29, 2015
Messages
35
Sorry... to clarify, I want to type 4 and have it show up as 4:00 I want to type 4.25 and have it show up as 4:15 type 4.5 and show up as 4:30 and 4.75 to show up as 4:45.
 

Repush

Board Regular
Joined
Sep 21, 2015
Messages
133
=4,25/24
or
=A1/24, when hour-value is in A1
expand to other cells, format as time
 

Watch MrExcel Video

Forum statistics

Threads
1,099,045
Messages
5,466,222
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top