Date conversion fun...

D

danieljharvey

New Member
Joined
Apr 24, 2008
Messages
17
Hi, has anybody got a formula for converting time in [h]mm:ss format to a decimal of hours. (7:30:00 to 7.5 hours)

Been searching around and can't find anything.

Cheers!
Dan
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Solved
Time conversion to existing formula
2
Replies
13
Views
406
awoohaw
awoohaw
A
  • Solved
Problem Subtracting 30 Minutes From Value
Replies
5
Views
98
Fluff
Fluff
T
  • Question
Timesheet For Building My Own Home For Tax Purposes
Replies
8
Views
170
etaf
etaf
W
  • Solved
Date and Time stamp when any part of worksheet is changed
Replies
1
Views
140
Woodpusher147
W
A
  • Question
Add a specified number of working hours to a date & time, given working day start, end and break times and holidays
Replies
2
Views
249
AquaBuoy
A

Forum statistics

Threads
1,214,940
Messages
6,122,356
Members
449,080
Latest member
Armadillos

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top