Find Jobs
Hire Freelancers

VBA convert time to nearest 15th minute block excel

$25-30 USD

Completed
Posted almost 13 years ago

$25-30 USD

Paid on delivery
I need a function for excel vba which will convert the time to the nearest 15 minutes block. This is the scenario: I want to multiply 0.73 to 26.25 hrs(the column is formatted to "h:nn" ) to get me 19.15 hrs( if the result is 19:18 (i.e. greater than 15 minutes)(then round it to 19:30 otherwise round it back to 19:00) Please let me know if you need any further clarifications. Thanks
Project ID: 3433452

About the project

4 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$25.50 USD in 1 day
5.0 (44 reviews)
5.4
5.4
4 freelancers are bidding on average $34 USD for this job
User Avatar
See private message.
$38.25 USD in 1 day
4.8 (40 reviews)
5.6
5.6
User Avatar
See private message.
$25.50 USD in 1 day
5.0 (4 reviews)
0.9
0.9
User Avatar
See private message.
$46.75 USD in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
5.0
137
Payment method verified
Member since May 24, 2001

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.