# Converting start date/start time end date/end time into time in minutes?

1. ## Converting start date/start time end date/end time into time in minutes?

Hi everyone,

I have a load of data on the barclays bicycle hire scheme, it gives me a starting date and time, and an ending date and time, I need to find a way of creating a new column displaying the time in minutes based on the information.

Here in a screenshot:

http://i43.tinypic.com/o7ixs1.jpg

As you can see I have attempted it myself but my formula wont work if the bike ride is over 2 days as opposed to the same day. I used =(F2+G2)-(D2+E2) so I added end date and time together and then subtracted start date and time from it, it works fine for rides on the same day but not if it's over a day long.

Any help would be appreciated.

Thanks.

2. ## Re: Converting start date/start time end date/end time into time in minutes?

That formula should work OK, just make sure you custom format column L as [h]:mm

The square brackets will ensure that durations over 23:59 are shown correctly

3. ## Re: Converting start date/start time end date/end time into time in minutes?

That formula should work OK, just make sure you custom format column L as [h]:mm

The square brackets will ensure that durations over 23:59 are shown correctly
I have that format [h]:mm but it's showing a 23 hour ride as 47 hours ;[.

http://i43.tinypic.com/15i1ame.png

4. ## Re: Converting start date/start time end date/end time into time in minutes?

How many days are there in July?

5. ## Re: Converting start date/start time end date/end time into time in minutes?

How many days are there in July?
Oh wow what an idiot, I scrolled back to June sorry to waste your time.

6. ## Re: Converting start date/start time end date/end time into time in minutes?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1