Microsoft Excell formatting...

Followers

26 July, 201213 yr

Ok I give in... Spent all day trying and got nowhere and I'm getting annoyed!

Hoping there's an Excell guru on Briskoda?!?

I need to change the format of time its showing from "01:26:12" (hh:mm:ss) to show it as "1.4333".

I'm aware I can simply work it out and manuall type it but I have 7 months worth of info to go thru so will take me longer than I will be alive to do that way!

Can anyone shed any light?!? (I have tried to change the format of the particular cells but it doesn't work.

Anyone have any bright ideas?!?

Thanks for looking

Jay

26 July, 201213 yr

Author

Ok I give in... Spent all day trying and got nowhere and I'm getting annoyed!

Hoping there's an Excell guru on Briskoda?!?

I need to change the format of time its showing from "01:26:12" (hh:mm:ss) to show it as "1.4333".

I'm aware I can simply work it out and manuall type it but I have 7 months worth of info to go thru so will take me longer than I will be alive to do that way!

Can anyone shed any light?!? (I have tried to change the format of the particular cells but it doesn't work.

Anyone have any bright ideas?!?

Thanks for looking

Jay

26 July, 201213 yr

if your time is in A1 and formatted as a number try this formula

=HOUR(A1)+MINUTE(A1)/60

I'll take all the credit for being a genius

until quesioned at which ponit i'll crumble and admit i found it on google

26 July, 201213 yr

***DOUBLE POST***

26 July, 201213 yr

Author

if your time is in A1 and formatted as a number try this formula

=HOUR(A1)+MINUTE(A1)/60

I'll take all the credit for being a genius

until quesioned at which ponit i'll crumble and admit i found it on google

Haha top man Cliff... I dont have enough work hours in the day to search the web!

Will try it in the morning!

27 July, 201213 yr

Author

Awesome, it worked, thanks again Cliff.

You're now responsible for 90 odd people hating me!!

Create an account or sign in to comment

Followers

Go to topic listing

No registered users viewing this page.

Announcements

About BRISKODA

BRISKODA is for the sharing of information on ŠKODA. Founded for all motoring enthusiasts, it's free to join and use. We have members from all over the world.

Our Guidelines.
Search the Site.
Explore the Forums.
Gaze into the Gallery.
Make a date, the Calendar.
Classic, custom or modified car insurance!
Please be respectful when posting.

See all Subscription Plans

Mk3 flickering xenon -> dead xenon -> no auto
Skoda Octavia Mk3 (2013 - 2020)

Mk3 flickering xenon -> dead xenon -> no auto

lhlied · Monday at 06:574 days

Hi. I got a xenon light that last week startet to act up with flickering. So I read here and understood and got confirmed that is the first on a path to have to change the xenon bulbs. My process was the following: Flickering right xeon light Turned off the lights a few days, then one day turned off and they both were dead, no life at all on auto at least. changed both left and right xenon. Surpriced how easy it was. The lights still dead after changed both to philips D3D bulbs. The ifht xen
- 1 reply
- 114 views
lhlied

Monday at 06:574 days

lhlied

4 hours ago4 hr
rattling noise - front calipers or pads
Skoda Octavia Mk2 (2004 - 2013)

rattling noise - front calipers or pads

kokosal · 28 June28 Jun

Hi guys My Octavia 2 FL makes rattling noise on rough asphalt, exposed stones, small cracks. Brakes, system ATE, disc 280mm, pads Febi 16328. When I press brake pedal quiet. When release rattling comes back. I even replaced one rubber sleeve. New Febi sleeve is more loose than orginal ATE Skoda OEM sleeve. I replaced guide pins for brand new ATE. MOT in March nothing in suspension. I know sway bar link clattering noise. I think left side is louder than right or it is noise from left wheel. Any
- 1 reply
- 115 views
kokosal

28 June28 Jun

kokosal

5 hours ago5 hr
Factory fitted electric towbar is not releasing after a long time not using
Skoda Superb Mk3 (2015 - 2023)

Factory fitted electric towbar is not releasing after a long time not using

candasm · 17 hours ago17 hr

Hi Everyone, I have a Factory fitted electric Tow bar. Last time I use, it was 5 years ago I believe. I tried to use it Today no chance not releasing. It has a green light always but whenever I pull it out light changes to red blinking and tow bar is not releasing. I used some wd-40 and rust cleaner but still result didn't' change. I also tried to pull out the tow bar with bare hand or hit the mechanism with a wood or hammer(kindly), still no chance. Anyone faced the same issue?
- 1 reply
- 73 views
candasm

17 hours ago17 hr

leolito

5 hours ago5 hr
Please help me solve my problem
Skoda Superb Mk3 (2015 - 2023)

Please help me solve my problem

AlexG145 · 15 hours ago15 hr

Hi everyone, I’m hoping someone here has come across this exact issue, because after 7 months and multiple visits, neither my dealer nor Škoda’s technical support has been able to identify the cause. Car: Škoda Superb Sportline, 2021, 200kW Problem: When braking, the side sensors intermittently trigger a warning that there is an obstacle very close to the car — even though there is nothing there. It happens sporadically (not every time I brake) What has already been done (all without success):
- 7 replies
- 166 views
AlexG145

15 hours ago15 hr

Cairus

5 hours ago5 hr
Creaking front-end
Skoda Superb Mk3 (2015 - 2023)

Creaking front-end

travs · Monday at 12:294 days

History is that since the coilovers were done, the front-left top mount has aways creaked on turning; classic top mount sound of juddering movement. I've tried rotating the spring a little in case that's a difference but I need to do try some more just to make sure I haven't forgotten anything. In the meantime, the front right has developed a creak which is different. It's a heavier creaky rubber feel to it which is triggered on minor movement/weight shift. Going over speedbumps obviously makes
- 12 replies
- 430 views
travs

Monday at 12:294 days

leolito

5 hours ago5 hr

Microsoft Excell formatting...

Featured Replies

Create an account or sign in to comment

Recently Browsing 0

About BRISKODA

Available Subscriptions

FREEDOM Lite

FREEDOM

Recent Topics

Mk3 flickering xenon -> dead xenon -> no auto

rattling noise - front calipers or pads

Factory fitted electric towbar is not releasing after a long time not using

Please help me solve my problem

Creaking front-end

Important Information

Account

Navigation

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)