bowelripper
New Member
- Joined
- Nov 21, 2009
- Messages
- 7
Hello!
I have a couple of questions concerning the use of time/hours in Excel 2007.
Firstly, it seems I have to use a colon for the time format. In other words 7 in the morning must be entered as 07:00 in a cell, but in Norway where I live the correct format is 07.00 (alternatively 0700). If I try the latter it just gets messed up. Is it possible to work with the latter format? How? (By the way, we use the 24-hour system here.)
Secondly, I have a formula where I need to state that if a certain hour in a cell is less than /earlier than 07:00 it should calculate a value. Example where let's say B8 equals 06:00: =IF(B8<07:00;(07:00-B8)*24;0). The problem is that Excel won't accept 07:00 as a value in the formula bar, so how can I reformulate this?
Thanks,
BR
I have a couple of questions concerning the use of time/hours in Excel 2007.
Firstly, it seems I have to use a colon for the time format. In other words 7 in the morning must be entered as 07:00 in a cell, but in Norway where I live the correct format is 07.00 (alternatively 0700). If I try the latter it just gets messed up. Is it possible to work with the latter format? How? (By the way, we use the 24-hour system here.)
Secondly, I have a formula where I need to state that if a certain hour in a cell is less than /earlier than 07:00 it should calculate a value. Example where let's say B8 equals 06:00: =IF(B8<07:00;(07:00-B8)*24;0). The problem is that Excel won't accept 07:00 as a value in the formula bar, so how can I reformulate this?
Thanks,
BR