Excel Help please (again) - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

Excel Help please (again)

mrsj2008 Avatar
6y, 3m agoPosted 6 years, 3 months ago
Thanks to everyone who helped me yesterday but sadly i've come across another problem.

How can I show time deficit? i.e, 3:00 - 4:30 should be -1:30 but instead it shows ########

many thanks
mrsj2008 Avatar
6y, 3m agoPosted 6 years, 3 months ago
Options

All Comments

(7) Jump to unreadPost a comment
Comments/page:
1 Like #1
Try putting capital O in instead of the number 0
#2
thanks but the numbers are automatically inserted using the formula {hh}:mm and it's the deficit difference between them that I need to find.
1 Like #3
Is the box wide enough to show the number? I have seen sometimes, if its not big enough you may get that...
3 Likes #4
In Options change to the 1904 data system works a treat then
#5
birdyboyuk - lol, tried that one. Apparently date and time function automatically go to ####### if it's a minus :(

Edited By: mrsj2008 on Oct 05, 2010 10:22: amend
#6
coddfather - you've saved me twice this week, thank you soooooooooooo much ;)
#7
coddfather2 people like this
In Options change to the 1904 data system works a treat then

Wow handy, I didn';t know that. I always used a formula such as

IF(A1-B1 < 0,CONCATENATE("-",TEXT((B1-A1),"hh:mm")),A1-B1)

to show the hours negatively and then use a hidden column to do the arithmetic

Here have some rep.. Oops sorry forgot it's been taken away (_;) never mind repped you in my hed



Edited By: trog0 on Oct 06, 2010 03:40: worked out how to put in <

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!