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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

S
  • Question
Using IFS to calculate a task due by date but needing to remove weekends
Replies
3
Views
81
awoohaw
awoohaw
P
  • Solved
Time conversion to existing formula
2
Replies
13
Views
409
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
171
etaf
etaf
D
  • Question
Rounding Negative time to the nearest minute in Excel
Replies
4
Views
90
Scott Huish
Scott Huish

Forum statistics

Threads
1,215,053
Messages
6,122,888
Members
449,097
Latest member
dbomb1414

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