Calculating total from hours

[mikerules]

I am trying to calculate total hours

In A1 8:00
In A2 5:15
In A3 I am looking to populate 9.25 as the total hours

[boopathiraja]

If formatted as time

Please Login or Register  to view this content.

If its text values

Please Login or Register  to view this content.

Else post a sample

[sktneer]

Assuming that
A1 = Start Time
A2 = End Time
then try this...

Please Login or Register  to view this content.

and format as General.

[Danerida]

Deleted.....

[mikerules]

I have attached an example. As you can see I can't get the total as I need it. I am not sure if maybe it is the formatting?

[boopathiraja]

HI, Refer the attachment

[Vikas_Gautam]

Try this formula..

Please Login or Register  to view this content.

and then select the formula cell
and press Ctrl + Shift + ! will give you 9.25 as desired..

Ctrl + Shift + ! is an shortcut for changing the format to number...

[Punnam]

hi mikerules,

The issue is with the input data in case of half an hour to be filled ":30" is not the correct method time format is "hh:mm:ss"
hh stands for Hours
mm stands for minutes
ss stands for seconds

taking an example for half an hour
hh is 00 , mm 30 ss 00 the time format to be entered is 00:30:00

Try this punnam

[mikerules]

I understand however the employees will never enter it correctly or know to and I want it to allow them to just enter :30 Is there a way to format this so they can do it

[Punnam]

@ mikerules ,

1) Are you talking only about the lunch time or even the rest other fields also,
2) As you said "employees will never enter the data correctly" , at least you would be able to provide the improper data or raw data for a better solution

Punnam

[mikerules]

I think the solution is to put the hours and lunch time in a drop down formatted as it should be and they just pick.

Thanks for your help

[Punnam]

Yes that will be a good one

Punnam

[Punnam]

mikerules,

If your question is answered & solved mark the thread solved using the thread tools

Punnam